摘要:
一直使用以下的SQLSET NOCOUNT ON -- Table row counts and sizes.CREATE TABLE #t ( [name] NVARCHAR(128), [rows] CHAR(11), reserved VARCHAR(18), data VARCHAR(18), index_size VARCHAR(18), unused VARCHAR(18)) INSERT #t EXEC sp_msForEachTable 'EXEC sp_spaceused ''?''' -- Order by size (nee 阅读全文