Changes to existing commands

alter table

The new partition clause allows you to create additional page chains for a table with no clustered index. The new unpartition clause allows you to concatenate all page chains for a partitioned table.

buildmaster

The buildmaster -r flag is no longer supported.

delete

New clauses allow specifying the index, cache strategy, and I/O size for a query.

reconfigure

The reconfigure command is no longer required to activate changes made with sp_configure. reconfigure is now non-operational. Scripts using reconfigure will still run, but should be changed at your earliest convenience, as reconfigure may not be supported in future releases.

select

New clauses allow specifying the index, cache strategy, and I/O size for a query. The new at isolation clause allows you to specify the isolation level for the query.

set showplan

Changes to output.

set transaction isolation level

New isolation level option: 0

update

New clauses allow you to specify the index, cache strategy, and I/O size for a query.