sqlserver表压缩

 行压缩，表被压缩后非聚集索引需要单独压缩

--表压缩
ALTER TABLE test REBUILD PARTITION = ALL
WITH ( DATA_COMPRESSION = ROW );
--非聚集索引压缩
ALTER INDEX [PK_ANNEXFILELIST] ON test   REBUILD PARTITION = ALL
WITH ( DATA_COMPRESSION = ROW );

 页压缩

--表压缩
ALTER TABLE test REBUILD PARTITION = ALL
WITH ( DATA_COMPRESSION = page );
--非聚集索引压缩
ALTER INDEX [PK_ANNEXFILELIST] ON test   REBUILD PARTITION = ALL
WITH ( DATA_COMPRESSION = page );

创建表时进行压缩

create table test
(
    id int,
    name varchar(20)
)
with (data_compression=row)