My Columnstore index DMV script failed on SQL Server 2012 RTM because sys.column_store_index_stats was gone. What I found next, with sys.dm_db_index_usage_stats.
Columnstore Indexes for Reporting Tables
Columnstore indexes for reporting tables can cut scan work, but clustered and nonclustered designs affect loading and point lookups differently.
Finding the Worst Query in Five Minutes With Query Store
Find the worst query with Query Store totals, compare CPU and duration over the last day, inspect plans, and choose the first tuning target.
Tuning Step One: Capture a Wait Stats Baseline Before Changing Anything
Capture a wait stats baseline, compare two saved snapshots, reject reset intervals, and rank meaningful waits before changing settings.
SQL SERVER – Transcript of Learning SQL Server Performance: Indexing Basics – Interview of Vinod Kumar by Pinal Dave
Many readers asked to read my interview with Vinod Kumar instead of watching it. Here is the transcript on Learning SQL Server Performance: Indexing Basics.
SQL SERVER – Speed Up! – Parallel Processes and Unparalleled Performance – TechEd 2012 India
At TechEd India 2012 I present Speed Up! Parallel Processes and Unparalleled Performance, a SQL Server tuning session built from what stumped me.
SQL Server – Learning SQL Server Performance: Indexing Basics – Interview of Vinod Kumar by Pinal Dave
Readers wanted insight into our indexing course, so I did an interview of Vinod Kumar on why indexes matter so much for SQL Server performance.