Why is Batch Mode Fast? - SQL Server Query Optimization

Offered By: SQLBits via YouTube

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Explore the intricacies of SQL Server and Synapse query optimization in this 49-minute SQLBits conference talk. Delve into the evolution of database engine performance from SQL Server 7.0 to modern systems, examining concepts like Instructions Per Cycle (IPC) and their impact on query execution. Learn about ColumnStores and the advantages of Batch Mode processing over traditional Row Mode. Discover how Batch Mode leverages parallelism and SIMD instructions (AVX) for enhanced scalability. Gain insights from Conor Cunningham, an architect for the SQL core database engine at Microsoft with over 20 years of experience, as he unravels the secrets behind lightning-fast query performance in SQL Server and Synapse.

Syllabus

Intro
SQL Server 7.0 - Pentium Era
Instructions Per Cycle (over HW generations)
Bit counting IPC example
Modern CPU Takeaways To Maximize Perf
ColumnStores, Batch Mode
Row Mode vs. Batch Mode
Batch Mode Details
Batch Mode vs. Row Mode Parallelism Batch Mode
Scalability
SIMD instructions (AVX)

Taught by

SQLBits

Related Courses

Stanford Seminar - MIPS Open, Wave Computing
Stanford University via YouTube Loop Analysis and Vectorization in Julia - JuliaCon 2020
The Julia Programming Language via YouTube Intrinsic Functions and Vector Processing Extensions for SIMD Parallel Operations in C++
javidx9 via YouTube Intrinsics - Low-Level Engine Development with Burst - Unite Copenhagen
Unity via YouTube Aggregating Ticks to Manage Scale in Sea of Thieves - Unreal Fest Europe 2019 - Unreal Engine
Unreal Engine via YouTube