Is there a DMV to replace the DBCC INPUTBUFFER command? An interview question that caught me off guard, answered with sys.dm_exec_input_buffer.
SQL SERVER – 2016 – Wait Stats and Queues Script Updated – Identify Resource Bottlenecks
My popular Wait Stats and Queues script, now updated for SQL Server 2016. It works on 2008, 2012 and 2014 too and helps you identify resource bottlenecks.
SQL SERVER – How to Downgrade SQL Server Edition?
A vendor installed Enterprise Edition without the license. Here is how to downgrade SQL Server edition, say from Enterprise to Standard, on the same version.
How to Find Recent Executed Queries in SQL Server? – Interview Question of the Week #087
An interview question that stumped candidates: how do you find recent executed queries in SQL Server? A DMV script using sys.dm_exec_query_stats answers it.
SQL SERVER – DMVs to Detect Performance Problems in SQL Server – Notes from the Field #135
[Notes from Pinal]: Performance tuning is a complex subject, SQL SERVER – DMVs to Detect Performance Problems in SQL Server.
SQL SERVER – Script: Change Service Account Using WMI / SMO
How do you manage 1000 SQL Servers without clicking through each one? Here is the script I use to change service account for all instances with WMI and SMO.
SQL SERVER – Identify Time Between Backups Calculation
A DBA whose latest tape backup was corrupt wanted to know the possible data loss. This script uses backup history to calculate the time between backups.