Resolutions found in SQL Server, Oracle, Teradata, and other issues
This one also surprises me that someone has not already posted. The TD_Month_Of_Year function returns an integer value that need to converted to string value. Careful when using this on … Continue Reading →
This surprises me that someone has not already posted this. The TD_Day_of_Week function returns an integer value that need to converted to string value. Careful when using this on a … Continue Reading →
Problem: This morning when working with one of my SQL Server servers, I went looking for an error log from last August. After finding that I was only able to … Continue Reading →
There are times I need to know if a scheduled server reboot has occurred. Below works on both Windows Server 2012 & Windows Server 2016. 1. On the server, right … Continue Reading →
Recently I received an e-mail alert that my collect statistics job had a spool space error (“Failure 2646 No more spool space in…”) for one of the statements it ran … Continue Reading →
A user was unable to connect to Teradata from Toad DataPoint using a Microsoft Active Directory account. When I looked at the user account in Teradata, it was showing as … Continue Reading →
A rookie developer reached out to me requesting help to move a couple of tables to a new schema. Thinking the developer did not have permissions to the one of … Continue Reading →
Working with some new monitoring software, I need to locate the directory of the SQL Server’s Errorlog. This location is not standard and differs by each version of SQL Server. … Continue Reading →
While working to get my Oracle database upgraded to a supported version, using the DBUA I was getting the following errors: ORA-04031: unable to allocate 704 bytes of shared memory … Continue Reading →
Probably the fastest way to enable Query Store for a database is run the “ALTER DATABASE” command in a query window. First check that the database is not already have … Continue Reading →