The disadvantages of sp_spaceused are:
It may report inaccurate counts for row total and space usage.
Output is only in kilobytes, while most query-tuning activities use pages as a unit of measure. However, you can use sp_spaceusage to report information in any unit you specify.
