table Table의 File Group 옮기기 declare movetable cursor local fast_forward for Select distinct A.name From sys.sysobjects AS A INNER JOIN sys.indexes as i on A.id=i.object_id INNER JOIN sys.sysindexes AS B ON A.id = B.id INNER JOIN sys.sysfilegroups AS C ON B.groupid = C.groupid WHERE C.groupid=1 and a.id>100 and b.name is not null and A.xtype='U' and a.uid=1 and i.type=1 open movetable declare @table varchar(100) fetch from .. 운영/데이터베이스 2019. 7. 18. 테이블 압축 여부 확인하기 MS SQL 2008 Enterprise에서 Page 압축을 지원하는데, 압축 여부를 확인하기 1. 테이블 압축 여부 확인하기 SELECT I.name, P.data_compression, P.data_compression_desc FROM sys.partitions AS P JOIN sys.objects AS O ON P.object_id=O.object_id JOIN sys.indexes AS I ON P.object_id=I.object_id AND P.index_id=I.index_id WHERE I.object_id IN ( SELECT object_id FROM sys.objects WHERE name='테이블이름') 2. 결과 확인 운영/압축 2013. 12. 1. 이전 1 다음
