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 *

Attend my Live Training on September 29, 2022:

SQL Server Availability Groups

EUR 590 incl. 20% VAT