Why is Batch Mode Fast? - SQL Server Query Optimization

Why is Batch Mode Fast? - SQL Server Query Optimization

SQLBits via YouTube Direct link

SQL Server 7.0 - Pentium Era

2 of 11

2 of 11

SQL Server 7.0 - Pentium Era

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. 1 Intro
  2. 2 SQL Server 7.0 - Pentium Era
  3. 3 Instructions Per Cycle (over HW generations)
  4. 4 Bit counting IPC example
  5. 5 Modern CPU Takeaways To Maximize Perf
  6. 6 ColumnStores, Batch Mode
  7. 7 Row Mode vs. Batch Mode
  8. 8 Batch Mode Details
  9. 9 Batch Mode vs. Row Mode Parallelism Batch Mode
  10. 10 Scalability
  11. 11 SIMD instructions (AVX)

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.