2

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?

1

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

| improve this answer | |
  • MERGE works fine regardless of compatibility level, though. – Aaron Bertrand 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.