Understanding Full Text Search in SQL Server 2005: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
Understanding Full Text Search in SQL Server 2005

page 7 of 7

by Uday Denduluri
Feedback

Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 21567/ 439

Article Contents:

Conclusion

Full-text search allows fast and flexible indexing for keyword-based query of text data stored in a Microsoft SQL Server 2005 database. There are many enhancements made to the full-text search. In sql server 2005 it uses the MSSearch functionality. The concept of ranking is also included in this version. Ranking can give a score about the relevance of the search made. In this article we tried to expose all the basic functionalities of full-text search.

« (Page 6)

View Entire Article

Article Feedback

Comment:
Title:
Name:
Url:	( Optional )

Please add 5 and 4 and type the answer here:

User Comments

Title: Understanding Full Text Search in SQL Server 2005
Name: Sanjeev
Date: 11/13/2008 12:24:53 PM
Comment:
Good article for Beginers , Thanks for sharing .
Please explain other advanced topics soon in full text .

Thanks

Title: make it simple
Name: Neela
Date: 11/1/2008 12:26:48 AM
Comment:
want to make catalogue for differant cat.please explain in simple language

Title: Try to explain more next time....
Name: WebEye
Date: 9/5/2008 11:48:52 PM
Comment:
Try to explain more next time....

Title: Mr.
Name: Hitesh
Date: 7/30/2008 12:37:47 PM
Comment:
Good Article.

Title: Usless
Name: Programmer
Date: 7/8/2008 5:02:18 AM
Comment:
More details please

Title: Mr
Name: Prasad
Date: 5/7/2008 2:34:49 PM
Comment:
Good Article for beginers

Title: Mr
Name: khodor
Date: 4/21/2008 4:52:41 PM
Comment:
it is a good in general but i want more example about freetext table and containstable

Title: SQL Full Text Search - storage
Name: Jack Kangas
Date: 12/24/2007 3:46:39 PM
Comment:
You mention that section on MSFTESQL (a windows service) - manages "the full text catalogs taht are stored within SQL Server"

I just created an index and there is now 75 meg of files in a catalog folder on the machine. What is in those .ci, .dir and .wid files?

I am asking because I am concerned about security on the words that are in the full text index. If anyone could read the words in those files (that are external to SQL Server's normal MDB, NDB, and LDB files.

Title: SQL Full Text Search
Name: Saurabh Sharma
Date: 12/9/2007 11:52:07 PM
Comment:
Another gr8 one article.

Title: SQL Full Text Search
Name: SAuarbh Sharma Software Engineer.
Date: 12/9/2007 11:50:47 PM
Comment:
It's Really Helpful and gr8 article. Thanx.

Title: SQL Full Text Search
Name: Nitin Sharma Software Engineer
Date: 12/3/2007 10:53:50 PM
Comment:
Great one..!!