MSSQL的数据库中每个表行数和体积的计算

select count(*)和sp_spaceused得到的有关记录数的结果不一致可能性有

DBCC UPDATEUSAGE (0, 'tablename') WITH COUNT_ROWS 用这个可以纠正这个错误

---テープル件数と容量の検証用

CREATE TABLE #SPACES
([name][sysname],[rows][bigint],[reserved][varchar](10),
[data][varchar](10),[index_size][varchar](10),[unused][varchar](10))
DECLARE @table sysname

DECLARE C CURSOR LOCAL FOR 
SELECT name FROM sysobjects 
WHERE XTYPE='U'

OPEN C
FETCH NEXT FROM C INTO @table

WHILE (@@FETCH_STATUS=0)
BEGIN
INSERT INTO #SPACES EXEC sp_spaceused @table
FETCH NEXT FROM C INTO @table
END

CLOSE C
DEALLOCATE C

SELECT * FROM #SPACES
ORDER BY name

DROP TABLE #SPACES