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.

Like or share to get the source code.

Thanks for your time,



  • golam kabir

    good as usual

  • 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.

  • Your Name

    Where is the source code?

    Excellent insights!

It`s your turn

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


Copyright © 2018 by SQLpassion e.U. · Imprint · Offerings · Academy · Contact · Data Protection · Go to Top