I ran sp_spaceused and Disk Usage by Top Tables standard report for a table.
The results for sp_spaceused are:
name rows reserved data index_size unused
SomeTable <1301755> <7691344 KB> <3931672 KB> <3673840 KB> <85832 KB>
However Disk Usage by Top Tables report shows:
Table Name # Records Reserved (KB) Data (KB) Indexes (KB) Unused (KB)
SomeTable 1.301.755 4.340.216 3.931.672 324.776 83.768
Record count is the same but there is a big gap between the two in terms of space used. sp_spaceused shows 7.691.344 KB as reserved while the report shows 4.340.216 KB. Which one is correct?
EXEC sys.sp_spaceused @objname = N'dbo.SomeTable', @updateusage = 'true';