Discussion with a client during the Comprehensive Database Performance Health Check. The topic is AdHoc Queries and Optimize for Adhoc Workloads.
Handling Duplicate Key Errors 2627 and 2601 in a CATCH Block
Handle duplicate key errors 2627 and 2601 in TRY CATCH, preserve unexpected errors, and avoid racing existence checks during inserts.
SQL SERVER – Map SQL Server Session ID to OS Thread ID
He wanted to track the OS Thread ID in Performance Monitor. He asked me if I know any script which can Map SQL Server Session ID to OS Thread ID.
Top 5 SQL in Sixty Seconds Videos
I have received lots of views and comments over them. Today we will be seeing the top 5 SQL in Sixty Seconds Videos.
JDBC and sendStringParametersAsUnicode: The Hidden Index Scan
Diagnose sendStringParametersAsUnicode conversions, align JDBC parameters with varchar indexes, and preserve required Unicode data.
SQL Puzzle – SELECT ~ 1 : Guess the Answer
Of course, I have one where you have to guess the answer for a simple select statement. Let us see if you can guess it correctly or not.
NOT IN With a NULL in the List Returns No Rows
See why NOT IN with a NULL returns no customers, then compare five sample rows, NOT EXISTS, an IS NOT NULL filter, and query plans.