This post has been republished via RSS; it originally appeared at: Channel 9.
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