Full Text Search in SQL 2005 - the teen age
I attended yesterday a webcast about Full Text Search in SQL 2005. Lord, things are moving pretty well for FTS.
View as a poor child in SQL 2000, now finally Microsoft has realized that it could be a great tool for the next SQL generation.
Some stats : Indexing 20 Million rows in Sql 2000 14 days, the same with FTS 2005 -- > 10 hours !
Well I still have to find a database of this dimension to check by myself, but pretty impressive. The secret behind is a better batch indexing process.
What I like is the new Thesaurus feature. You can now search for 'car' and get the results you have with 'automobile'. The question I have is at the moment I don't see any fully populated Thesaurus by default installed. Maybe a third-party can create one ready to use.
Backup and restore are possible now. Same for deployment detaching-attaching a database.
What I dislike is still the Rank. The speaker yesterday was not really convincing on the meaning of the Rank. What many want is a clear score value we can transform as a percentage for example. Any ideas on how to do this with the current FTS 2000?
Finally I expect some cool book about FTS 2005. It will be natural now that FTS is back as a full SQL entity.