Full-Text Search Concepts

Article
12/03/2008

Microsoft SQL Server 2005 contains the functionality you need to issue full-text queries against plain character-based data in Microsoft SQL Server tables. Full-text queries can include words and phrases, or multiple forms of a word or phrase.

Topic	Description
Introduction to Full-Text Search	Introduces you to terminology associated with Full-Text Search and other fundamentals and also provides you with a business scenario.
Full-Text Search Architecture	Describes the architecture of Full-Text Search and also describes the new Microsoft Full-Text Engine for SQL Server (MSFTESQL) service.
Administering Full-Text Search	Explains deployment and administration concepts associated with Full-Text Search.
Querying SQL Server Using Full-Text Search	Describes the different types of queries that you can run using Full-Text Search.
International Considerations for Full-Text Search	Provides information on how to specify a language when creating a full-text index and also lists the languages supported by Full-Text Search.
Troubleshooting Full-Text Search	Provides answers to frequently-asked questions and basic troubleshooting information.
Full-Text Search How-to Topics	Contains step-by-step instructions for performing various tasks with Full-Text Search.
Item Finder Sample	This sample application showcases the full-text features introduced in SQL Server 2005 using the new AdventureWorks sample database.