chrisfradenburg (11/22/2016)
A reorg can only move pages withing the file that they're in. I would need to do a rebuild or drop and create to handle this. We're going to meet with the owners of this database and talk about whether or not it's worth adding a second file group and work on moving things over to avoid this in the future or if we should do a drop and then shrink the file so no new pages can be allocated before recreating but I expect that to be an even more painful exercise to get all non-system objects out of that file.Thanks for your help.
For non-clustered indexes you do not need to drop-recreate.
You may first create a copy-index (with a slightly modified name) and then drop the original one.
Should not make an impact on the system performance.