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

  • 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.