dbcc listoam output has changed substantially.
The space state message printed in the old dbcc listoam output is now available as a new column spacestate in sysobjects.
dbcc tablealloc output has changed.
dbcc checktable output on a partitioned table has been changed to provide partition-level information.
dbcc checktable/tablealloc/indexalloc has new syntax for partition support.
Output for this command has changed:
REORG RECLAIM_SPACE <tablename> with RESUME
reorg rebuild fails with message 11051 when table is in use by other tasks.
Output of sp_dbcc_faultreport has been enhanced to show partition ID information.
The hostname, program_name, hostprocess, and cmd columns in sysprocesses have been changed to varchar(30) and made nullable. select from sysprocesses returns NULL for these columns instead of space for system tasks.
The “first” column in sysindexes has been moved to the “firstpage” column in syspartitions.
The name column in syspartitions has been changed from index_name+_+tableid to index_name+_+ptn_id for partition table with indexes.
The basic cost of the optimizer now includes CPU cost.
Parallel costing is now performed only on base tables and indexes that are larger than 20 pages.
For information about trace flags and diagnostics, see the Query Processor document.
