Capture actual plans with SET STATISTICS XML, save the extra result safely, inspect runtime fields, and compare last-known plan statistics.
Memory-Optimized tempdb Metadata: Turning It On and Checking It
Diagnose memory-optimized tempdb metadata candidates, plan the required restart, verify activation, and monitor contention and memory.
The Handful of Counters That Actually Matter
Make SQL Server monitoring useful by relating waits, batch activity, memory indicators, and file latency to the same workload and observation window.
Many-to-Many Merge Join and the Worktable in STATISTICS IO
Diagnose a many-to-many merge join and its worktable, verify true uniqueness, and compare join choices without changing legitimate matches.
Indexed Computed Columns: Speeding Up Code You Cannot Change
Use indexed computed columns to help fixed vendor queries on UPPER or CAST, while checking determinism and required SET options.
SQL SERVER – A Brief History of Deadlock and Modern Approach of Resolution
A deadlock investigation needs the graph and cooperation between DBAs and developers. I distinguish a blocking wait from a cyclic dependency.
Async Statistics Updates: Stopping Queries From Stalling
Diagnose synchronous statistics refresh waits, enable async statistics updates, and judge when fresh estimates still matter more.







