Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Huge cost issue with Temp DB using 2008r2 sp2 RE: Huge cost issue with Temp DB using 2008r2 sp2

  • November 11, 2012 at 3:51 pm

    #1557984

    Thanks Jeff,

    I have zipped both plans up.

    1. Long running Plan.sqlplan - this is the one that is taking longer SQL2008R2 (problematic)

    2. Quick plan.sqlplan - This is the 2005 box that is rather quick to execute.