This week’s Data Exposed show welcomes Joe Sack into the Channel 9 studio. Joe is a Principal PM on the SQL Server team, and is in the Channel 9 studios today to show us the awesome Adaptive Query Processor technology, the ability of the database to adapt based on customer characteristics in real-time conditions. Joe introduces 3 features of Adaptive QP in SQL Server 2017 and Azure SQL DB.
Today’s AQP topics:
[02:20] – Memory Grant Feedback
[08:50] – Adaptive Joins
[16:20] – Interleaved execution
For more on Adaptive Query Processing, visit our docs page here:
https://docs.microsoft.com/en-us/sql/relational-databases/performance/adaptive-query-processing