Home Archives Authors Categories Latest Builds About Search

Author: Paul White

Paul White (@SQL_Kiwi) is an independent SQL Server technical consultant with 25 years experience, specializing in performance tuning the SQL Server Core Engine, and is well known for his expertise in execution plans, the query processor, and the query optimizer. Currently living in New Zealand, Paul writes the SQL Server internals blog Page Free Space. Over the years, Paul has worked internationally on a number of high-volume critical systems where ultimate performance and reliability were the primary goals. A SQL Server MVP from 2011 to 2022, he contributes regularly to a range of web sites and forums, including Database Administrators Stack Exchange. Paul has also spoken at a variety of user groups and community events such as SQL Saturdays and the annual SQL Pass Summit.
Database smarter with deeper insights for Microsoft SQL
Aggregates and Partitioning

Paul White (@SQL_kiwi) talks about a regression in the optimizer's handling of aggregates against partitioned tables when moving from SQL Server 2005 to SQL Server 2008+.

  ◆  July 18, 2013
0
The Halloween Problem – Part 4

The Halloween Problem has a number of important consequences for SQL Server execution plans. In this final part of the series, we look at some of the tricks the optimizer uses to avoid adding an Eager Table Spool to every update query that might encounter the Halloween Problem.

  ◆  February 20, 2013
15
The Halloween Problem – Part 3

The MERGE statement (introduced in SQL Server 2008) allows us to perform a mixture of INSERT, UPDATE, and DELETE operations using a single declarative statement. The Halloween Protection issues for MERGE are, logically enough, mostly a combination of the requirements for the individual operations performed, but there are some important differences and a couple of optimizations that apply only to MERGE.

  ◆  February 18, 2013
4
The Halloween Problem – Part 1

Much has been written over the years about understanding and optimizing SELECT queries, but rather less about data modification. This series of posts looks at an issue that is specific to INSERT, UPDATE, DELETE and MERGE queries – the Halloween Problem.

  ◆  February 13, 2013
9