SQL Server Quickie #32 – Temp Tables vs. Table Variables

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.

Like or share to get the source code.

Thanks for your time,

-Klaus

3 thoughts on “SQL Server Quickie #32 – Temp Tables vs. Table Variables”

  1. Frederik Vanderhaegen

    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.

Leave a Comment

Your email address will not be published. Required fields are marked *

Enjoy one of my newest Online Trainings:

Design, Deploy, and Optimize SQL Server on VMware

EUR 699 incl. 20% VAT