SQL Server Features & Components, Fast Focus

SQT06 Fast Focus: From Adaptive to Intelligent: Query Processing in SQL 2019

11/19/2019

2:00pm - 2:20pm

Level: Intermediate

Hugo Kornelis

Freelance Database Developer/Consultant

As announced in September 2018, SQL Server 2019 expands the "adaptive query processing" features of SQL 2017 and relabels them as "intelligent query processing". This name now covers many features, such as batch mode on rowstore, memory grant feedback, interleaved execution, adaptive joins, deferred compilation, and approximate query processing.

In this high-paced session, we will look at all these features and cover some use cases where they might help - or hurt! - you.

You will learn:

  • Understand the limitations and problems in the classic SQL Server query optimization / execution model
  • Understand the benefits of the features released in SQL Server 2017 as "Adaptive Query Processing"
  • Understand the benefits of the features released in SQL Server 2019 as "Intelligent Query Processing"