Unanswered: Alter / Drop index that are using Daily partitions
Another wonderful question for the board.
I have some indexes I am trying to rebuild that are using daily partitions. Is there a way to drop specific partitions from the index I need to rebuild and then only rebuild the index for the partitions that were dropped?
Or do I need to drop the entire Index and rebuild the entire thing?