[MSSQL] 테이블 사용량 확인 쿼리문

SELECT CONVERT(VARCHAR(30), MIN(B.name)) AS TableName, 

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

  FROM sysindexes AS A

       INNER JOIN sysobjects AS B ON A.id = B.id

 WHERE A.indid IN (0, 1, 255)

   AND B.xtype = 'U'

 GROUP BY A.id

 ORDER BY SUM(reserved) * 8192.0 / 1024.0 DESC