Review columnstore bulk load batch sizes, inspect delta and compressed rowgroups, and measure the cost of forcing small groups to compress.
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.
Index Size Estimate: Sizing an Index Before You Create It
Before you build an index, estimate its size and say what you assumed. Then check the guess against real pages on a copy.
When to Use sort_in_tempdb for Rebuilding Indexes? – Interview Question of the Week #207
When should you use sort_in_tempdb for rebuilding indexes? A DBA asked me in a Health Check, and the simple answer is when TempDB sits on fast, separate drives.
SQL SERVER – Unable to Uninstall – Index was Outside the Bounds of the Array
My machine crashed mid-install, and uninstalling SQL Server 2017 then failed with: Index was outside the bounds of the array. This is how I cleaned it up.
Columnstore Rowgroup Health: Finding Small and Open Rowgroups
Inspect columnstore rowgroup health, understand small and deleted groups, and choose reorganize or rebuild from measured evidence.
SQL SERVER – Optimize Key Lookup by Creating Index with Include Columns
A query slowed to over 10 minutes because of a big key lookup. Here is how I optimize key lookup operations by creating an index with include columns.