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
Allocation Order Scans

Paul White (@SQL_Kiwi) explains various ways SQL Server makes runtime decisions about whether to use the b-tree structure or perform allocation order scans.

  ◆  January 23, 2015
11
Rewriting Queries to Improve Performance

Paul White (@SQL_Kiwi) looks at a couple of cases where – even though T-SQL is supposed to be a declarative language, and any query that uses the same logic and same semantics should ultimately lead to the same plan and comparable performance – rewriting queries can change the plan in dramatic ways.

  ◆  September 3, 2014
3
The SNAPSHOT Isolation Level

Paul White (@SQL_Kiwi) continues his series on ACID and transaction isolation levels in SQL Server, giving us fair warning about some potential issues with the SNAPSHOT isolation level.

  ◆  June 30, 2014
10