Today I have uploaded SQL Server Quickie #32 to YouTube. This time I’m talking about the difference between Temp Tables and Table Variables in SQL Server.
Thanks for your time,
-Klaus
SQLpassion Performance Tuning Training Plan – Signup
Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.
3 thoughts on “SQL Server Quickie #32 – Temp Tables vs. Table Variables”
good as usual
I think when you execute the stored procedure multiple times, you’ll see there is only a recompilation the first time.
The second time nothing will be recompiled.
Where is the source code?
Excellent insights!