
复制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.