Database compatibility level 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?
There are plenty of differences.  One that comes to mind right away is the MERGE statement, which first became available in 2008.