SP_helpdb 和 sp_spaceused 数据一致, database_size空间为2292443.94 MB， 但是我用
网友的语句把所有的表的reserved加起来就和上面的2个结果相差很大，只有649210.91MB。为什么差这么大呢，求大神指教。
网友语句如下：
============================
use cboc_rewards
CREATE TABLE #tmpTableSizes
(
tableName varchar(100),
numberofRows varchar(100),
reservedSize varchar(50),
dataSize varchar(50),
indexSize varchar(50),
unusedSize varchar(50)
)
insert #tmpTableSizes
EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?'"
select * from #tmpTableSizes
order by cast(LEFT(reservedSize, LEN(reservedSize) - 4) as int) desc
DROP TABLE #tmpTableSizes
============================
SP_helpdb ‘cboc_rewards’ 结果
-------------------------------
name db_size owner dbid created status compatibility_level
-------------------------------- ------------- -------------------------------------------------- ------ ----------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ -------------------