테이블 용량 확인 및 레코드수 조회 쿼리

--테이블 별 용량 확인

SELECT table_name = convert(varchar(30), min(o.name)) 

, table_size = ltrim(str(sum(cast(reserved as bigint)) * 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_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 o.name

출처 : http://blog.naver.com/PostView.nhn?blogId=2zerox&logNo=90175823040&categoryNo=11&parentCategoryNo=0&viewDate=&currentPage=1&postListTopCurrentPage=1&userTopListOpen=true&userTopListCount=15&userTopListManageOpen=false&userTopListCurrentPage=1