The output of sp_help object has
been changed. Specifically, Data_Located_on_segment has
been removed, while Computed_Column_Object and
information related to partitions have been added.
The order of index_keys and index_description in the output of sp_helpindex has been changed.
Major changes have been made to the output of sp_helpartition and sp_helpsegment.
sp_who returns “NULL” instead of blank in the hostname column for all system tasks.
sp_who results in SQL command (insert or select) in the output. In earlier versions, sp_who returned select for the tasks that executed sp_who.
sp_objectsegment now displays segment information for all partitions of the table.
sp_lock output has a new column called partitionid, that currently has a value of 0, and is reserved for future use.
sp_monitorconfig now accepts number of open partitions. When this procedure is executed with the parameter all, additional output for configuration parameter number of open partitions is displayed.
The Metadata Cache Management section of sp_sysmon displays additional information pertaining to open partitions.
