SQL Server Quickie #32 – Temp Tables vs. Table Variables
(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.)
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
3 Comments
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!