Decode wait_resource for blocked requests, map KEY and PAGE locks to objects, and keep undocumented row-hash checks on test copies.
SQL SERVER – How to Turn On / Enable Instant File Initialization?
This follow-up to my IFI posts shows how to turn on and enable Instant File Initialization when it is disabled, with a method that works for nearly every version.
SQL SERVER – Observation: ROWLOCK Hint and Slow Performance
Does a ROWLOCK hint make a query faster? For my client it made it slower, and a simple WideWorldImporters example shows why the ROWLOCK hint can hurt.
Practical Real World Performance Tuning – Class Preparation and Setup
Part three of my behind the scenes series on Practical Real World Performance Tuning: my class preparation and setup, right before and after each class.
Practical Real World Performance Tuning – Fun and Reviews
Part two of my behind the scenes story of Practical Real World Performance Tuning: the fun we had in class and the reviews our students shared.
Local Variable Estimates: Why the Density Vector Wins
Understand local variable estimates with skewed data, density calculations, parameter comparisons, and targeted OPTION RECOMPILE tests.
SQL SERVER – Optimal Value Max Worker Threads
DBAs panicked when they saw Max Worker Threads set to zero. Should it match your CPU count? Here is what zero really means and the optimal value to use.