What is Full Text Search?
This is the search functionality which enables a fast and easy way of searching text based data in SQL Server. Even though, full text search is not new to SQL Server 2005, there are some enhancements in performance and manageability of SQL Server 2005.
Why Full Text Search?
This is used as a replacement to LIKE queries to search a pattern in a large data set since, LIKE doesn’t yield the exact results in a huge data sets.
· In a huge data set, LIKE query behaves very slowly and it may take several minutes to return the results.
· LIKE query doesn’t work on formatted binary data.
Full text search is fast, efficient, can also be run on unstructured text data and supports for different data types like formatted binary.
Components of Full Text Search
MSFTESQL – Microsoft Full Text Engine for SQL Server
MSFTEFD – Microsoft Full Text Engine Filter Daemon which contains Filter, Protocol handler and Word breaker
Architecture
MSFTESQL is a windows service that is tightly integrated with SQL Server 2005 which used as a search engine and built on top of MSSearch technology. The service provides,
· Implementing full text catalogs and indexes for database
· Querying the DB with words, phrases and words in close proximity
· Managing the full text catalogs that are stored in SQL Servers
Early Bites 