 Print
 Add To Favorites
 Email To Friend
 Rate This Article
|
Understanding Full Text Search in SQL Server 2005
|
Published:
03 Dec 2007
|
Abstract
This article exposes the concept of Full text search. It also explains the architecture of full-text search indexing along with the enhancements made to it in SQL Server 2005. |
 |
by Uday Denduluri
Feedback
|
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days):
19413/
543
|
|
|
|
| Introduction |
Full text search is the search functionality that enables a fast
and easy way of searching text based data in SQL Server. Although the concept
of full text search is not new in SQL Server 2005, there are considerable
enhancements in performance and manageability of SQL Server 2005. In this
article we will discuss the usage of full text search and the architecture of
full text search in detail. We will also compare full text search with other
search options "Like" and discuss the reason for the superior
functionality set of full-text search.
|
|
|
|
|
Article Feedback
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..!!
|
|
|
|
|
|
