I would like to know what the implications for my database might be to swap from compat mode 90 (2005) to 100 (2008). Are there any performance enhancements? Are there any deprecated features?
views:
39answers:
2
+1
A:
The compatibility mode doesn't have anything to do with performance or similar. It's just the syntax of T-SQL on what it allows and don't allow
Vidar Nordnes
2010-07-28 09:08:35
+1
A:
There are no direct performance benefits, but the behaviour of TSQL is different. The topic "ALTER DATABASE Compatibility Level" in Books Online lists the differences between level 100 and previous levels.
Pondlife
2010-07-28 10:07:43