Partitioning and Columnstore Concepts
- Partitioning and columnstore concepts (10 minutes)
- Download scripts, slides, and wallpaper
Partition and Rowgroup Elimination
- Disk based rowstore: actual plans, cached plans, and Query Store (21 minutes)
- Columnstore: 0 partitions accessed- but rowgroup elimination! (15 minutes)
- More fun with rowgroup elimination and predicate pushdown (12 minutes)
- When doing more is less work: comparing Query Time Stats for two queries (5 minutes)
Hacking Batch Mode for Rowstore
- When you can get batch mode operators, and an example of their power (14 minutes)
- Batch mode hacks, and what does the future hold? (9 minutes)
Quiz and Course Highlights
- QUIZ TIME!
- Concepts to remember, and thank you! (4 minutes)
SQLChallenges come out each month for registered students.
Check out the schedule and sign up for notifications here.
⭐ Scheduling is underway for future recording sessions ⭐