Data Exposed  - Channel 9

SQL Server 2017 Adaptive QP


Listen Later

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
...more
View all episodesView all episodes
Download on the App Store

Data Exposed  - Channel 9By Microsoft