Menu
SQL Server Full-Text Search computes rank based on the frequency of the word in the document and in the set of all documents (TFIDF). Is it possible to access these values directly ?
I would like to find the top-n most frequent words in my table. Is it possible to obtain this list from the full-text search index?
I'm using SQL Server 2005.
608
Full-Text Search in SQL Server and Azure SQL Database lets users and applications run full-text queries against character-based data in SQL Server tables.
On a table that has a full-text index, you can manually disable or re-enable a table for full-text indexing using SQL Server Management Studio. Expand the server group, expand Databases, and expand the database that contains the table you want to enable for full-text indexing.
Look at the list of services on the machine. If full text search is installed you'll see a service named SQL Server FullText Search ([instance]) where [instance] will be the name of the SQL instance that it is associated with.
I don't know of an easy way to do this on SQL Server 2005, but on 2008 there are two Transact-SQL commands do exactly what you need.
100
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
