In order to speed up a field's datatype change, I:
- completely dropped the Full Text Catalog and a few NC indexes.
- changed the datatype (from
- recreated the NC Indexes.
- recreated the FTC.
Before this change the NDF was 100gb and 6gb free space. After the change the NDF was still 100gb from with 99gb free space (and I looked at the FTI status and it was idle and fully populated).
Why would recreating the FTI make the overall size so much smaller? There were a ton of tables in the FTC that I didn't add back in there, but those tables didn't have any columns checked. The FTI only indexes the tables were there are actual columns checked, right?