代码改变世界

随笔分类 -  SQL

SQL Sever check table size

2019-07-29 16:28 by nuswgg, 317 阅读, 收藏,
摘要： SELECT t.NAME AS TableName, s.Name AS SchemaName, p.rows AS RowCounts, SUM(a.total_pages) * 8 AS TotalSpaceKB, CAST(ROUND(((SUM(a.total_pages) * 8) / 阅读全文