테이블별 사이즈 및 Row 수 체크하기

테이블별 용량 및 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