Paul White (@SQL_Kiwi) is an independent SQL Server technical consultant with 15 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 at SQLblog.com.
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 recently re-awarded SQL Server MVP, he contributes regularly to a range of web sites and forums, including Stack Exchange, SQL Server Central, SimpleTalk, and MSDN. Paul also speaks at a variety of user groups and community events such as SQL Saturdays and the annual SQL Pass Summit.
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 […]