Home Forums SQL Server 2008 SQL Server 2008 - General Partitioning Table with Page Level Compression on Data and Indexes without losing compression RE: Partitioning Table with Page Level Compression on Data and Indexes without losing compression
Tom John-342103
SSCrazy
Points: 2694
More actions
January 11, 2017 at 1:52 pm
#1922063
After doing some reading, it seemed to be a better idea to rename the original table and create a new table set up with PAGE compression using the desired partitions and copy the data into that table.