MS-SQL 테이블들 row count , Data size check

-- 용량별 소팅

SELECT 

    table_name = convert(varchar(30), min(o.name))

    --, table_size = convert(int, ltrim(str(sum(reserved) * 8192 / 1024., 15, 0)))

,table_size = sum(reserved)

, UNIT = '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

-- 테이블별 Row 수

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.id