Intelligent Query Processing? What’s up with that?
One of the major changes in SQL Server 2017 and 2019 is addition of Intelligent Query Processing, which includes a number of improvements to the way queries are optimised and executed.
This session will show why this is a radical departure from the way that things worked previously and how it can improve the performance of some query forms. We’ll look at the places where Intelligent Query Processing works and compare the performance of queries using these features to see just what kind of improvement it can make.
Gail is a Database Specialist focusing on database performance tuning and database recovery, with a particular interest in topics such as indexing strategies, execution plans, and writing T-SQL code that performs well and scales gracefully.
Gail holds a Microsoft Certified Master certification for SQL Server 2008 and is a Data Platform MVP. She is a frequent poster on the SQL Server Central forums, writes articles for both SQLServerCentral.com and Simple-Talk.com, and has spoken at SQL Saturdays locally and internationally, SQL Bits and at the PASS Community Summit.
Gail has been responsible for extending the lifespan of many an application by performance-tuning their databases as well as providing technical guidance on all things SQL Server related. She lives in Johannesburg, South Africa.