Data Platform User Group (Intelligent Query Processing, SQL Server)

Join fellow IT Professionals for an evening of knowledge sharing and networking in an open, friendly environment.

17:50 – 18:00 – Quick update and mic check.

18:00 – 19:00 – Gail Shaw (SQLintheWild) - Intelligent Query Processing? What’s up with that? (300/400)

One of the major changes in SQL Server 2017 and 2019 is the 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.

About Gail
Gail Shaw is a database specialist from Johannesburg, South Africa, specializing in performance tuning and database optimization.

Gail works for Entelect, a medium-sized custom software development house based in Johannesburg.

Gail is an MVP for SQL Server and holds the Microsoft Certified Master certification for SQL Server