This page contains the description for my conference session “From adaptive to intelligent: query processing in SQL 2019”, and links to the slide deck and demo code used in this presentation.
|Target audience||Experienced database developers and DBAs.|
|Short description||An overview of the new “Intelligent Query Processing” features that will be introduced in SQL Server 2019: What are they, where do they help you, and what are the risks?|
|Duration||The ideal length for this session is 60 – 75 minutes.|
|Full abstract||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.
This session has not yet been presented. I am still working on the slide deck and the demos, and will probably continue to do so until shortly before it is first presented. The “final” version of the slide deck and demo code will be uploaded here around the time I first deliver this session.
(Note: my presentations tend to evolve over time, so the version you find here may not be an exact match for the version you witnessed)