Tag SQL Server work with SESSION_CONTEXT, read tags in audit defaults and modules, and handle read-only values and pooled connections.
SQL SERVER – Split Comma Separated Value String in a Column Using STRING_SPLIT
To Split Comma Separated Value String inputs, I use STRING_SPLIT with CROSS APPLY. The example associates each class with its student.
SQL SERVER – Installation Wizard Hang Forever – Please Wait on Feature Selection Page
Adding Analysis Services to SQL Server 2014, the Installation Wizard hung on “Please Wait” at feature selection, even after my lunch. Here is what fixed it.
SQL SERVER – Get Wait Stats Related to Specific Session ID With sys.dm_exec_session_wait_stats
From SQL Server 2016, sys.dm_exec_session_wait_stats shows wait stats for a specific session ID. Here is how to use it, and why it fails on older versions.
SQL SERVER 2016 – Trace Flag 1117 is Discontinued. Use the Options Provided with ALTER DATABASE
SQL Server 2016 discontinued trace flag 1117 and 1118 for TempDB. Use the options in ALTER DATABASE instead, as I found on a client server.
How to Find Number of Times Function Called in SQL Server? – Interview Question of the Week #104
A function was causing CPU spikes. How many times was that function called, and at what cost? The SQL Server 2016 DMV dm_exec_function_stats shows it.
SQL SERVER – CLONEDATABASE: Generate Statistics and Schema Only Copy of the Database
CLONEDATABASE can Generate Statistics and schema-only diagnostic copies without copying table rows. I use that distinction when investigating optimizer behavior.