SQL Server 2008行数据和页数据压缩解密
复制USE tempdb GO CREATETABLE TestCompression (col1 INT,数据数据 col2 CHAR(50)) GO INSERTINTO TestCompression VALUES (10, compression testing) GO 5000 -- Original EXEC sp_spaceused TestCompression GO -- DATA_COMPRESSION = ROW ALTERTABLE TestCompression REBUILD WITH (DATA_COMPRESSION = ROW); GO EXEC sp_spaceused TestCompression GO -- DATA_COMPRESSION = PAGE ALTERTABLE TestCompression REBUILD WITH (DATA_COMPRESSION = PAGE); GO EXEC sp_spaceused TestCompression GO -- DATA_COMPRESSION = NONE ALTERTABLE TestCompression REBUILD WITH (DATA_COMPRESSION = NONE); GO EXEC sp_spaceused TestCompression GO 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.
本文地址：http://www.bzve.cn/html/689c8799223.html
版权声明
本文仅代表作者观点，不代表本站立场。
本文系作者授权发表，未经许可，不得转载。