Page Free Space

Parallel Index Building Execution Plan SQL Server doesn't support parallel modifications to a b-tree index. That might sound surprising....

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

Reducing Contention on the NESTING_TRANSACTION_FULL latch Each additional worker thread in a parallel execution plan ex...

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

Empty Parallel Zones An empty parallel zone is an area of the plan bounded by exchanges (or the leaf level) containing...

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

How MAXDOP Really Works A few days ago I ran a Twitter poll: The most popular answer gets highlighted by Twitter at ...

Parallel Execution Plans Suck Summary : A deep dive into SQL Server parallelism, and a potential performance problem wi...

Forcing a Parallel Query Execution Plan This article is for SQL Server developers who have experienced the special kind...

Bitmap Magic (or… how SQL Server uses bitmap filters) Question Can a parallel query use less CPU than the same serial...

How Parallelism Works in SQL Server You might have noticed that January was a quiet blogging month for me. Part of the...

Myth: SQL Server Caches a Serial Plan with every Parallel Plan Many people believe that whenever SQL Server creates an ...