Resolutions found with SQL Server and other types of databases
When applying a hotfix update to SQL Server 2012, the step where “Check File In Use” produced the following error: The ‘fdhost.exe’ process is not controlled by the update wizard. … Continue Reading →
Problem: This was a compound problem I had on a production SQL Server 2014 instance. First was someone who scheduled a couple of load jobs at the same time which … Continue Reading →
This query will bring back only those databases where the Query Store is enabled in the SQL Server instance. — Show All Query Store Enabled Databases select name as ‘DATABASE … Continue Reading →
If the Query Store, from an SQL Server 2016 instance or greater, information is missing, it may be because the version of the SQL Server Management Studio is not at … Continue Reading →
Warning: this method of changing SQL Server’s default collation is not supported by Microsoft The issue was an instance of SQL Server was installed with the default collation (SQL_Latin1_General_CP1_CI_AS), and … Continue Reading →
Stopping & Starting the services for Teradata Viewpoint are the same in Teradata Express as they would be on an actual Teradata Viewpoint server. Recently I needed to do this … Continue Reading →
After reading an old article about the SQL Server DMV sys.dm_os_wait_stats running on SQL Server 2005. I learned about the undocumented trace flag 8001, which enables all the wait types … Continue Reading →
When attempting to drop a database that I created for temporary use, I received the following error when I ran the “DROP DATABASE < database name >” command: DROP DATABASE … Continue Reading →
Recently, I was notified of this error in the alert log of one of my Oracle 12.1.0.2 databases: ORA-00600: internal error code, arguments: [723], [140432], [960048], [memory leak], [], [], … Continue Reading →
The problem with the table DBC.AccessRights is that the data is not something easily readable. Many of the columns use a 4-byte IDs. By joining a couple of tables to … Continue Reading →