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 Live Class Season Pass, Live Class Season Pass PLUS Lab VM, Recorded Class Season Pass or Fundamentals of TempDB, or log in if you already shelled out the cash.

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 Live Class Season Pass, Live Class Season Pass PLUS Lab VM, Recorded Class Season Pass or Fundamentals of TempDB, or log in if you already shelled out the cash.
Menu
{"cart_token":"","hash":"","cart_data":""}