MSSQL 테이블 Size 구하기

     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