Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Fundamentals of TempDB
Before the Class
Prerequisites
Introductions and Overview (7:19)
Download the Slide Decks & Scripts
Fundamentals of TempDB
How the Version Store Affects TempDB (27:57)
How Temp Tables Are Different from Regular Tables (31:31)
How Table Variables Can Be Better Than Temp Tables (21:26)
Temp Tables & Table Variables at Scale: PFS/GAM/SGAM Contention (42:41)
How Memory-Optimized Table Variables Reduce Contention (26:04)
How Execution Plans Use TempDB (31:26)
Other TempDB Consumers: Cursors, Index Builds, AG Statistics (17:37)
How to Provision and Monitor TempDB (24:31)
How Memory-Optimized Table Variables Reduce Contention
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock