mphelps - Tuesday, October 17, 2017 6:19 AMWe have a table with Page compression which is partitioned daily. Before upgrading from SQL 2014 to SQL 2016 each partition was using +/- 1.6GB in space. After the Upgrade the daily partitions are using double the space. Data volumes are consistent. Has anyone experienced this situation before?
Can you post the entire ddl for both the table and any indices please?
😎