合集-SQL SERVER

MSSQL 查询每个表的占用空间大小
摘要：SELECT t.NAME AS TableName, p.rows AS RowCounts, SUM(a.total_pages) * 8 AS TotalSpaceKB, SUM(a.used_pages) * 8 AS UsedSpaceKB, (SUM(a.total_pages) - S 阅读全文
posted @ 2024-03-14 15:30 清风神剑 阅读(271) 评论(0) 推荐(0)