Skip to main content
  • 422 Accesses

Abstract

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

eBook
USD 16.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 52.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Rights and permissions

Reprints and permissions

Copyright information

© 2008 Michael Coles

About this chapter

Cite this chapter

(2008). Integrated Full-Text Search. In: Pro T-SQL 2008 Programmer’s Guide. Apress. https://doi.org/10.1007/978-1-4302-1002-3_10

Download citation

Publish with us

Policies and ethics