3 – How Table Variables Affect TempDB

Table variables have a bad reputation because they don’t have statistics. When you go to pull data out of a table variable, SQL Server can’t accurately predict how many rows will come out, and this causes cascading problems in execution plans. But sometimes, that’s actually a good thing. If your SQL Server’s biggest performance problem…

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.

Table variables have a bad reputation because they don’t have statistics. When you go to pull data out of a table variable, SQL Server can’t accurately predict how many rows will come out, and this causes cascading problems in execution plans. But sometimes, that’s actually a good thing. If your SQL Server’s biggest performance problem...
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":""}