테이블별 용량 및 Rows 체크하기
SELECT table_name = convert(varchar(30), min(o.name)) ,Rows = rowCnt , table_size = convert(int, ltrim(str(sum(cast(reserved as bigint)) * 8192 / 1024., 15, 0))), 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,rowCnt ORDER BY table_size DESC