大数据量 数据库学习笔记

--查询数据库中所有表大小及数据量

SELECT 
OBJECT_NAME(id) tablename,
8*reserved/1024 reserved,
RTRIM(8*dpages/1024)+'Mb' used,
8*(reserved-dpages)/1024 unused,
8*dpages/1024-ROWS/1024*minlen/1024 free
,ROWS 
FROM  SYSINDEXES
ORDER BY reserved DESC