You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have a huge DB, partitioned by year, and some cleaning process remove monthly data older than retention period ( 10 years )
I free up some space shrinking old filegroups data files ( related to partition ) , but as reorg runs again it allocates a lot of new space because of index fragmentation generated by shrink.
I would like to skip index maintenance in old partitions, actually there's no way to do that
Is it possible to add a parameter to exclude some partitions in index maintenance procedure ?
The text was updated successfully, but these errors were encountered:
I have a huge DB, partitioned by year, and some cleaning process remove monthly data older than retention period ( 10 years )
I free up some space shrinking old filegroups data files ( related to partition ) , but as reorg runs again it allocates a lot of new space because of index fragmentation generated by shrink.
I would like to skip index maintenance in old partitions, actually there's no way to do that
Is it possible to add a parameter to exclude some partitions in index maintenance procedure ?
The text was updated successfully, but these errors were encountered: