Post reply

Insert Into vs Insert Statement Recompile in SQL Server 2008

  • May 6, 2011 at 1:26 am

    #249922

    I have a one stored procedure which executes the t-sql statement using sp_executesql.

    This t-sql code recompiles for everytime it runs using "INSERT INTO" but when I use "INSERT" only it will not recompile. What is going on here? :w00t:

    Here is sample:

    create table #test (id int)

    Recompile:

    insert into #test select id from mytable

    Not Recompile:

    insert #test select id from mytable

    Software/Hardware used:

    SQL Server 2008

  • May 6, 2011 at 2:07 am

    #1320834

    How have you tested?

    The first insert into a temp table will always recompile. Subsequent ones should not.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply