Diagnose synchronous statistics refresh waits, enable async statistics updates, and judge when fresh estimates still matter more.
Consulting 105 – Why Don’t I Want My Customers to Return for the Same Problem?
Learn to diagnose the same problem yourself, distinguish symptom relief from a root-cause fix, and know when a follow-up is useful.
Consulting 103 – Why Do I Assure SQL Server Performance Optimization in 4 Hours?
See how performance optimization in 4 hours follows focused triage, reviewed fixes, and a written action plan for the work that remains.
Wide Update Plans: What Every Extra Index Costs a Write
Inspect wide update plans, compare index-maintenance work with narrow updates, and read per-index counters without misreading STATISTICS IO.
Do Queries Always Respect Cost Threshold of Parallelism? – Interview Question of the Week #216
Do queries always respect the Cost Threshold for Parallelism? Not always, and a quick AdventureWorks test with the execution plan shows why.
Eager Index Spool: When the Plan Builds Its Own Index
Investigate an eager index spool, read seek keys and output, and compare a supporting index with the cost of rebuilding temporary storage.
What is Consolidation of Index? – Interview Question of the Week #212
What is consolidation of index? When a table has overlapping indexes, like one on Col1 and one on Col1, Col2, here is how I think about combining them.