SQL Server 2017 Adaptive QP | Data Exposed

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

REMEMBER: these articles are REPUBLISHED. Your best bet to get a reply is to follow the link at the top of the post to the ORIGINAL post! BUT you're more than welcome to start discussions here:

This site uses Akismet to reduce spam. Learn how your comment data is processed.