Here are the instructions to prepare for demonstrating Intelligent QP's latest round of features:
-
Download WideWorldImportersDW-Full.bak from https://aka.ms/wwidwbak
-
Enlarge the database using the following script (https://aka.ms/wwidwenlarge)
Demos (with more on the way!):
- Batch Mode Adaptive Join
- Interleaved Execution
- Batch mode memory grant feedback
- Row mode memory grant feedback
- Batch mode on rowstore
- APPROX_COUNT_DISTINCT
- Table variable deferred compilation
- Scalar UDF Inlining
Email IntelligentQP@microsoft.com if questions in the meantime.