Home Forums SQL Server 2008 SQL Server 2008 - General 2008 SP2 Recompile RE: 2008 SP2 Recompile

  • March 23, 2013 at 11:35 am

    #1600074

    Bobby Glover (3/23/2013)

    Thanks Steve, but what I'm trying to find out is what problems occur with it in SQL 2008 SP1.

    In 2008 SP1 the behaviour is exactly the same as in 2005, ie you still get the poor plan.

    Basically, what happened is this:

    SQL 2008 RTM: Attempt at creating optimal plan not safe for reuse. Resulted in an incorrect results bug. ie, not something you want to do.

    SQL 2008 SP1: Feature to create optimal plan not safe for reuse removed because of said incorrect results bug

    SQL 2008 SP2: Feature re-added correctly.

    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