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?

2
2

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

2
  • MERGE works fine regardless of compatibility level, though. Jul 19 '15 at 20:22
  • Good point. I was thinking of version rather than compatibility level.
    – TLaV
    Jul 19 '15 at 20:33

Not the answer you're looking for? Browse other questions tagged or ask your own question.