Completed
Intro
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Why is Batch Mode Fast? - SQL Server Query Optimization
Automatically move to the next video in the Classroom when playback concludes
- 1 Intro
- 2 SQL Server 7.0 - Pentium Era
- 3 Instructions Per Cycle (over HW generations)
- 4 Bit counting IPC example
- 5 Modern CPU Takeaways To Maximize Perf
- 6 ColumnStores, Batch Mode
- 7 Row Mode vs. Batch Mode
- 8 Batch Mode Details
- 9 Batch Mode vs. Row Mode Parallelism Batch Mode
- 10 Scalability
- 11 SIMD instructions (AVX)
