Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Gregory Larsen Stairway to Advanced T-SQL Level 5: Storing Data in Temporary Tables RE: Stairway to Advanced T-SQL Level 5: Storing Data in Temporary Tables

  • April 3, 2014 at 4:19 pm

    #1703131

    mario17 (4/3/2014)

    Thanks, Gregory !!

    I heard that these days ( after 2008R2) we don't need to CREATE #Temp , you can just do SELECT * INTO #TEMP FROM dbo.Table, it won't be any difference in performance, locking, multitasking etc...

    Not sure if I want to put any indexes on #temp how this will work, can I do SELECT INTO #TEMP and then Create IDX?

    Appreciate your feedback..

    Tx

    mario

    The ability to create and populate a Temp Table by using SELECT/INTO has existed since at least the RTM of SQL Server 6.5. And there will, many times, be a performance difference depending on what the end goal is. Lot's of times, SELECT/INTO will be a fair bit faster if no indexes are needed. "It Depends". 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)