It seems so simple at first: queries create temp tables, load data, and drop ’em. How hard can it be? Spectacularly tricky, as it turns out. Temp tables share some behaviors with real tables, but they also have their own tricky behavior when it comes to statistics and execution plans. We’ll start by creating a…
2 – How Temp Tables Affect TempDB
It seems so simple at first: queries create temp tables, load data, and drop ’em. How hard can it be? Spectacularly tricky, as it turns out. Temp tables share some behaviors with real tables, but they also have their own tricky behavior when it comes to statistics and execution plans. We’ll start by creating a…
To access this incredible, amazing content, you gotta get Recorded Class Season Pass or Fundamentals of TempDB, or log in if you already shelled out the cash.
- 0 – Prerequisites Before the Class
- 1 – How the Version Store Affects TempDB
- 3 – How Table Variables Affect TempDB
- 4 – Temp Tables and Table Variables at Scale: PFS/GAM/SGAM Contention
- 5 – Memory-Optimized Table Variables
- 6 – How Execution Plans Use TempDB
- 7 – Other TempDB Consumers: Cursors, Index Builds, AG Stats
- 8 – How to Provision and Monitor TempDB