As a rule of thumb if the fragments are higher than 30 then you should be looking at re-indexing (REORGANIZE). Simply run the script to see if any of your fulltext indexes require any action.
To read the rest of this article, and access thousands of other articles, we ask you to register on the site and subscribe to our newsletters.
Subscribing to our newsletters gets you:
Steve Jones Editor, SQLServerCentral.com