Turbocharge Workloads with Intelligent Query Processing

Edward Pollack

Intelligent Query Processing allows SQL Server to make dynamic, smarter decisions at runtime when processing queries. What’s more, these features are on by default when SQL Server is upgraded to a compatible version.

This session introduces the many features that comprise Intelligent Query Processing and how each can be critical to improving performance, especially on large or complex workloads. A modern view of optimization is presented that transcends the age-old idea of static, unchanging execution plans and the operators needed to tame them.

From Scalar UDF Inlining to Adaptive Joins to Memory Grant Feedback (and more), each component of Intelligent Query Processing will be discussed and demonstrated in detail. You’ll gain an understanding of how these features work, how to confirm their operation, and the best ways to take advantage of their benefits to save significant time, money, and resources for development teams.