We had too many indexes to consolidate, so I needed a query listing all the indexes with their key columns and included columns. Here is the script.
SQL SERVER – Update Table Statistics in Parallel with FULLSCAN
Update statistics with FULLSCAN ran forever because MAXDOP was 2 at the database level. Here is how we managed to update table statistics in parallel.
SQL SERVER – Say No To Database Engine Tuning Advisor
After 20 years with SQL Server, my advice is simple: say no to Database Engine Tuning Advisor. It was fine in 2000, but tuning has moved far beyond it.
WRITELOG Waits: Finding What Slows Transaction Log Writes
Diagnose WRITELOG waits with log-file latency, commit patterns, and measured choices for batching, storage, and durability.
Columnstore Bulk Load: Why Batch Size Decides Where Rows Land
Review columnstore bulk load batch sizes, inspect delta and compressed rowgroups, and measure the cost of forcing small groups to compress.
Why Attend 21 Essential Scripts: Performance Tuning for EVERYONE? – SQLBits 2019
Seats are nearly gone for my SQLBits 2019 pre-con 21 Essential Scripts: Performance Tuning for EVERYONE. A short video explains what I cover and why to attend.
Implicit Conversions That Quietly Turn Seeks Into Scans
Find implicit conversions in SQL Server plans, compare parameter and column types, and fix type contracts without losing Unicode data.