[MSSQL] 관리를 위한 쿼리들

* 테이블 별 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 o.name


* 테이블 별 사용량 확인

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_name

참고 - http://blog.vicki.co.kr/1006