Recommended updates when you use data compression and table partitions

When you use data compression and table partitions, you might change the schema of the table. For example, you might drop or add columns to the table. After this, you might notice that you encounter problems while you perform a DML query against the partitions. These problems include access violations, assertions, and database recovery failures. The problems occur because of incorrect maintenance of column information across the different partitions (partitions that were created before the schema change and partitions that were created after the schema change). Also, differences exist between what the physical rows indicate and the partition metadata.

You have to update your Microsoft SQL Server installations by using the fixes that are mentioned in the "More Information" section. Or, you have to use the alter index command to rebuild all partitions of all indexes of the affected table.