Can we enhance query performance without any code changes? Modifying applications can be an expensive endeavor or completely beyond your control. Therefore, developers and DBAs prefer that the query processor adapts to their workload requirements rather than relying on options and trace flags to improve performance. Adaptation is the foundational concept behind Intelligent Query Processing (IQP) in the latest versions of SQL Server.

In this fast-paced, demo-focused session, we’ll take a practical tour of IQP features introduced in SQL Server 2022, 2019, and 2017. You’ll see how each feature solves specific performance issues. We’ll also briefly cover how to enable these features at various scopes—server, database, session, or query—and identify those that rely on Query Store.

Attending this session will allow you to learn about the new capabilities of intelligent query processing and gain powerful tools to persuade your peers to upgrade SQL Server and databases to the latest build, both on-premises and in the cloud.