mssql 모든 테이블 용량 , 레코드수 쿼리

테이블당 사용량
select table_name = convert(varchar(30), min(o.name)), table_size = ltrim(str(sum(reserved) * 8192 / 1024.,15,0) + 'KB')
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 table_size desc, table_name

테이블당 레코드수
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 rows desc, o.name;