Changes that may affect existing applications

This section describes the system changes introduced in release 11.0 that may affect your applications if you are upgrading to release 11.5 from a pre-11.0 release. Topics covered are as follows:

New Transact-SQL keywords in release 11.0
Changes to SQL Server configuration
Subquery changes
Changes to showplan output in release 11.0
New caching strategies may affect performance
Upgrading database dumps
Partitions and physical data placement