How to Think Like the SQL Server Engine, Part 5: Table Variables, Temp Tables, and OPTION RECOMPILE

These three things aren’t bad by themselves – they’re actually fine, as long as you understand how they impact statistics and CPU. You’ll learn the background in this module.

[prasantakswain]

Brent, Is there any disadvantages of using more temporary tables ?

[damarh]

being spoiled by Brents new livestreams :) DANG! this sound like it's recorded in a bathroom :P

[dbalukehuang]

How about CTE? The same as table variables? Thanks,

[zabelzarock]

great but now I have to move to mysql for the costs of licensing in the cloud