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.idORDER BY table_size DESC -- 테이블별 Row 수SELECT o.name , i.rows FROM sysindexes i INNER JOIN sysobje..
2017. 11. 1.