MSServer、SQL查询全库数据大小
SELECT
TableName = obj.name,
TotalRows = prt.rows,
[SpaceUsed(KB)] = SUM(alloc.used_pages)*8
FROM sys.objects obj
JOIN sys.indexes idx on obj.object_id = idx.object_id
JOIN sys.partitions prt ...
转载
2019-06-24 09:33:16 ·
210 阅读 ·
0 评论