3

We are on SQL Server 2008 R2 and have DBs compatibility level set to SQL 2000 or 2005.

What are differences in compatibility level across the versions ?

Are there any advantages changing it to 2008 or higher?

Taher
  • 31
  • 1

1 Answers1

2

There are plenty of differences. One that comes to mind right away is the MERGE statement, which first became available in 2008.

TLaV
  • 151
  • 1