Integrated Full-Text Search


Full-text search (FTS) provides the tools necessary to perform linguistic searches in a wide variety of languages against data and documents stored in SQL Server. Each new release of SQL Server has improved on FTS support since its initial introduction in SQL Server 7.0. SQL Server 2008 carries on with this tradition of continuous improvement in FTS functionality. The new integrated FTS (iFTS) model provides tighter integration with the SQL Server query engine, greater transparency with new dynamic management views and functions, improved support for more languages, and better T-SQL administration and management tools. In this chapter, I’ll introduce the new generation of SQL Server iFTS functionality.


Query Plan Query Engine Tight Integration Inflectional Form Word Instruction 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Michael Coles 2008

Personalised recommendations