MSSQL TABLE당 사이즈 구하기 (sql server table size statistics)

SELECT CONVERT(VARCHAR(30), MIN(O.NAME)) AS T_NAME

,LTRIM(STR(SUM(RESERVED) * 8192.0 / 1024.0, 15, 0) + ' KB') AS T_SIZE

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 SUM(RESERVED) * 8192.0 / 1024.0 DESC

--ORDER BY T_NAME