[MSSQL] 테이블별 용량 row수

--테이블 ROWS수 카운트
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

--테이블별 사이즈를 mb단위로
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 TABLE_SIZE DESC