Inspect columnstore deleted rows, measure delete-bitmap overhead, and choose targeted REORGANIZE work before a heavier rebuild.
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.
Peak Concurrency: The Busiest Moment From Start and End Times
Counting sessions per day tells you nothing about overlap. Here is a small event-sweep query that finds the busiest moment, with the tie trap explained.
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.
Does ARITHABORT Setting Negatively Impact SQL Server Performance? – Interview Question of the Week #220
Does the ARITHABORT setting hurt SQL Server performance? Yes, because with ARITHABORT OFF SQL Server can build a very different plan and queries may slow down.
Countdowns in T-SQL: Days, Hours and Minutes Until an Event
A countdown that says 1 day for a one-second gap is counting boundaries, not time. Here is how to build one that tells the truth.
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.