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.
Continuing his series on row goals, Paul White explains how they can impact certain types of semi joins, and how you can spot these effects in showplan and trace flag output.
Paul White provides some great information about row goals, explaining why they're important to understand when examining why the query optimizer made a certain choice.
Paul White (@SQL_Kiwi) walks through a new trace flag in SQL Server 2016 designed to yield better execution plans (and performance) for queries involving computed columns.
