最近需要用到SQL Server的数据压缩命令,简单记录一下!
参考文献:
A Look Inside SQL Server Row and Page Compression
http://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/how-sql-server-data-compression/
创建带数据压缩的表:
CREATE TABLE TestRowCompression
( ItemID INT ,
ItemName CHAR(50) ,
DateAdded DATETIME ,
UnitPrice MONEY ,
ItemLength DECIMAL ,
ItemWidth DECIMAL )
WITH ( DATA_COMPRESSION = NONE)
--WITH ( DATA_COMPRESSION = PAGE)
--WITH ( DATA_COMPRESSION = ROW)
修改现有表的压缩方式:
ALTER TABLE dbo.TestRowCompression REBUILD
WITH (DATA_COMPRESSION = NONE);
ALTER TABLE dbo.TestRowCompression REBUILD
WITH (DATA_COMPRESSION = ROW);
ALTER TABLE dbo.TestRowCompression REBUILD
WITH (DATA_COMPRESSION = PAGE);
目前暂时够用了!