Many teams skip comments in stored procedures, fearing bigger execution plans. My demo shows SQL Server ignores tabs, spaces and comments when it builds a plan.
SQL SERVER – Puzzle – Why Such a Complicated Execution Plan for a Single Row, Single Table Query?
A simple puzzle: why does SQL Server show such a complicated execution plan for a single row, single table query on WideWorldImporters? Try to solve it.
SQL SERVER – Backup to URL – Script to Generate the Create Credential and Backup Command using Access Keys
Backup to URL can use a SAS token or access keys. Here is a script that builds the CREATE CREDENTIAL and BACKUP commands from your Azure storage access keys.
How to Generate Random Password in SQL Server? – Interview Question of the Week #181
Question: How to Generate Random Password in SQL Server?
Answer: This is a fantastic question and here is the script to generate a random password in SQL Server
How to Check Edition Specific Features Enabled In SQL Server? – Interview Question of the Week #180
Moving databases to another edition? Here is a simple script for SQL Server 2008 and later that lists the Edition specific features each database uses.
SQL SERVER – Many BACKGROUND Threads with Command VDI_CLIENT_WORKER
Seeing many BACKGROUND threads with command VDI_CLIENT_WORKER? Here is what the VDI_CLIENT_WORKER and VDI_CLIENT_OTHER wait types mean.
SQL SERVER – Unable to Start SQL Resource in Cluster – HUGE Master Database!
A client’s SQL Resource would not come online on either cluster node. The ERRORLOG showed a very slow recovery of a huge master database. Here is the fix.