The advantages of sp_spaceused are:
It provides quick reports without excessive I/O and locking, since it uses only values in the table and index OAM pages to return results.
It shows the amount of space that is reserved for expansion of the object, but not currently used to store data.
It provides detailed reports on the size of indexes and of text and image, and Java off-row column storage.
