New answers tagged shrink
Yes, this is possible. Here is how Create a copy of the table (you can use the partition management tool for that: https://sqlpartitionmgmt.codeplex.com/) Switch the partition you want to "compress" into the copy Rebuild the indexes on the copy with FF = 100. Switch the partition back into the original table It should be pretty trivial to automate this ...
Top 50 recent answers are included