MSSQL 테이블 용량, 건수 확인 쿼리

[ 테이블별 용량 확인 쿼리 ]

SELECT table_name = convert(varchar(30), min(o.name)) 
     , table_size = convert(int, ltrim(str(sum(reserved) * 8.192 / 1024., 15, 0)))
     , UNIT = 'MB'
FROM sysindexes i 
INNER JOIN sysobjects o ON (o.id = i.id) 
WHERE i.indid in (0, 1, 255) 
AND o.xtype = 'U' 
GROUP BY i.id 
ORDER BY 2 desc

[ 테이블별 건수 확인 쿼리 ]

SELECT o.name, i.rows
FROM   sysindexes i           
INNER JOIN sysobjects o ON i.id = o.id
WHERE  i.indid < 2   
AND o.xtype = 'U'
ORDER BY i.rows DESC