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?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community