Install SQL Server Management Studio (SSMS) 2016 Without Internet Access: One of my frustrations with SQL Server 2016, is that the SQL Server Management Studio (SSMS) is no longer included with the database instance installation. It is now has its … Continue Reading →
Error: 9002, Severity: 17, State: 4 – The transaction log for database ‘tempdb’ is full due to ‘ACTIVE_TRANSACTION’
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 →
List Query Store Enabled Databases in SQL Server
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 →
Query Store Information Missing In SQL Server Management Studio (SSMS)
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 →
Changing the SQL Server Default Collation Without Reinstall or Rebuilding the Master Database
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 Teradata Viewpoint Services
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 →
Is Trace Flag 8001 still relevant
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 →
TERADATA ERROR – DROP DATABASE Failed. 3552:
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 →
ORA-00600: internal error code, arguments: [723], [140432], [960048], [memory leak]
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 →
How To Find All Access Rights In Teradata
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 →
Msg 14604, Level 16, State 1 Error When Changing A Database Mail Account
When attempting to change an email account in my Database Mail, I received the following error: Msg 14604, Level 16, State 1, Procedure sysmail_verify_account_sp, Line 14 Both account parameters (id … Continue Reading →