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.
KeywordsQuery Plan Query Engine Tight Integration Inflectional Form Word Instruction
Unable to display preview. Download preview PDF.