Page Free Space

Erik Darling ( @erikdarlingdata ) shared an interesting SQL Server execution plan with me recently. The demo script is at the end of this ar...

Why Batch Mode Sort Spills Are So Slow Batch mode sorting was added to SQL Server in the 2016 release under compatib...

More Consistent Execution Plan Timings in SQL Server 2022 The updated showplan schema shipped with SSMS 19 preview 2 c...

Incorrect Results with Parallel Eager Spools and Batch Mode You might have noticed a warning at the top of the release ...

SQL Server 2019 Aggregate Splitting The SQL Server 2019 query optimizer has a new trick available to improve the perfor...

Batch Mode Bitmap Demos This is a companion post to my main article Batch Mode Bitmaps in SQL Server . This post provid...