TABLE 용량, 건수 확인

-- DB용량

sp_helpdb TestDB

-- 테이블당 용량 내림차순

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

       -- t_name ASC

       SUM(reserved) * 8192.0 / 1024.0 DESC

-- 테이블당 건수 내림차순

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

       i.rows DESC