[MSSQL] 테이블별 용량 row수
--테이블 ROWS수 카운트 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 --테이블별 사이즈를 mb단위로 SELECT TABLE_NAME = CONVERT(VARCHAR(30),MIN(O.NAME)), TABLE_SIZE = CONVERT(INT,LTRIM(STR(SUM(RESERVED)*8.192 / 1024,15,0))), UNIT = 'MB' FROM SYSINDEXES I INNER JOIN SYSOBJECTS O ON O.ID = I.ID WHERE I.INDID IN (0,1, 255) AND O.XTYPE ..
serverSide/MSSQL
2014. 9. 10. 13:21