Compatibility Level

• Paul Liadis

  SSC Veteran

  Points: 209

  More actions

  March 2, 2007 at 1:01 pm

  #177044

  I have recently upgraded my databases from SQL Server 2000 to SQL Server 2005 using attach database. Currently, all of my databases are set to compatibility level of "SQL Server 2000". Will I see any performance gains by switching these databases to "SQL Server 2005" or any performance loss by leaving them at "SQL Server 2000"? I plan on setting them to "SQL Server 2005" at some point, but was just curious to know what the performance issues are (if any).

  Thanks,

  Paul

• MohammedU

  SSCoach

  Points: 19644

  More actions

  March 2, 2007 at 6:04 pm

  #692954

  If your sql code is compatible and tested for 2005...

  I don't see any reason not to use cmpt 90 instead of 90...

  You should see some benifit cause of all improvements in 2005...

   

  MohammedU
  Microsoft SQL Server MVP