Page Free Space

This article was originally published on 𝕏. I was asked recently why Halloween Protection was needed for data modification statements tha...

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

Closest Match with Sort Rewinds In When Do SQL Server Sorts Rewind? I described how most sorts can only rewind when th...

A bug with Halloween Protection and the OUTPUT Clause Background The OUTPUT clause can be used to return results fro...

Ranking Function Optimizer Transformations In my last post I showed how SQL Server 2005 and later can use a Segment ...

Partitioning and the Common Subexpression Spool SQL Server 2005 introduced the OVER clause to enable partitioning of...