Paul White, Author at SQLPerformance.com

Another Reason to Use NOEXPAND hints in Enterprise Edition

Paul White (@SQL_Kiwi) goes into detail about another reason you'll want to use the NOEXPAND hint, even when using Enterprise Edition.

Paul White ◆ December 30, 2015

6

Optimizing Update Queries

Paul White (@SQL_Kiwi) spends some time optimizing update queries in order to explore some SQL Server internals.

Paul White ◆ December 16, 2015

3

Hash Joins on Nullable Columns

Paul White (@SQL_Kiwi) discusses some less well-known query optimizer features and limitations, and explains poor performance of certain hash joins.

Paul White ◆ November 3, 2015

18

Interesting things about INSTEAD OF triggers

Paul White (@SQL_Kiwi) discusses some things to know about INSTEAD OF triggers – from execution plans and worktables to a cardinality estimation bug in SQL 2014.

Paul White ◆ September 11, 2015

10

Improving the Top / Top Descending Median Solution

Back in January 2015, my good friend and fellow SQL Server MVP Rob Farley wrote about a novel solution to the problem of finding the median in SQL Server versions prior to 2012. As well as being an interesting read by itself, it turns out to be a great example to use to demonstrate some […]

Paul White ◆ August 6, 2015

2

Improving the Row Numbering Median Solution

Paul White (@SQL_Kiwi) takes another look at medians, this time describing how a locking hint can help improve the performance of a pre-2012 solution.

Paul White ◆ July 28, 2015

2

Locking and Performance

Paul White (@SQL_Kiwi) follows up a great post on calculating medians with some information on how locking can affect query performance, often undetected.

Paul White ◆ July 20, 2015

1

Calculating the Median with a Dynamic Cursor

Paul White (@SQL_Kiwi) demonstrates another case where a cursor might be the most efficient approach to solving a typically set-based problem: medians.

Paul White ◆ July 15, 2015

0

Internals of the Seven SQL Server Sorts – Part 2

Paul White (@SQL_Kiwi) concludes his two-part series on SQL Server sort internals, including two new classes specific to In-Memory OLTP in SQL Server 2014.

Paul White ◆ May 7, 2015

1

Internals of the Seven SQL Server Sorts – Part 1

Paul White (@SQL_Kiwi) rolls up his sleeves in his usual way, showing off the debugger several times while explaining the internals of SQL Server sorts.

Paul White ◆ April 29, 2015

6

The Read Uncommitted Isolation Level

With detailed information and his uncanny knack for explaining technical concepts very well, Paul White (@SQL_Kiwi) concludes his series on ACID, transactions, and isolation levels in SQL Server with a great read on READ UNCOMMITTED.

Paul White ◆ April 23, 2015

9