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

[@dexter_johnson]

Very informative as usual.

[@prasantakswain]

Very useful .. Thanks

[@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

[@dbalukehuang163]

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

[@TheBrentOzar]

You can read about that here: www.brentozar.com/archive/2019/06/whats-better-ctes-or-temp-tables/

[@zabelzarock6161]

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

[@BrentOzarUnlimited]

Maybe if you spent more time making money and less time commenting on UA-cam videos, you'd be able to afford nice things.