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,

-Klaus

2 Comments

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

It`s your turn

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

SQLpassion

Copyright © 2015 by SQLpassion · Klaus Aschenbrenner · Imprint · Offerings · Academy · Contact · Go to Top