Apress Access

Pro Full-Text Search in SQL Server 2008

By Hilary Cotter , Michael Coles

  • eBook Price: $34.99
Buy eBook Buy Print Book

Pro Full-Text Search in SQL Server 2008 Cover Image

SQL Server 2008 provides the tools to take advantage of the features of its built-in enterprise-level natural-language search engine in the form of integrated full-text search (iFTS).

Full Description

  • Add to Wishlist
  • ISBN13: 978-1-4302-1594-3
  • User Level: Beginner to Advanced
  • Publication Date: December 1, 2008
  • Available eBook Formats: PDF

Related Titles

  • High Performance SQL Server
  • Expert Scripting and Automation for SQL Server DBAs
  • DevOps, DBAs, and DBaaS
  • Securing SQL Server
  • Beginning SQL Server R Services
  • Database Systems
  • Relational Database Programming
Full Description

Businesses today want actionable insights into their data—they want their data to reveal itself to them in a natural and user–friendly form. What could be more natural than human language? Natural–language search is at the center of a storm of ever–increasing web–driven demand for human–computer communication and information access. SQL Server 2008 provides the tools to take advantage of the features of its built–in enterprise–level natural–language search engine in the form of integrated full–text search (iFTS). iFTS uses text–aware relational queries to provide your users with fast access to content. Whether you want to set up an enterprise–wide Internet or intranet search engine or create less ambitious natural–language search applications, this book will teach you how to get the most out of SQL Server 2008 iFTS:

  • Introducing powerful iFTS features in SQL Server, such as the FREETEXT and CONTAINS predicates, custom thesauruses, and stop lists
  • Showing you how to optimize full–text query performance through features like full–text indexes and iFilters
  • Providing examples that help you understand and apply the power of iFTS in your daily projects

What you’ll learn

  • Harness the power of iFTS for your applications
  • Administer iFTS catalogs and indexes
  • Use new iFTS features such as stop lists and iFTS–based dynamic management functions
  • Optimize and tune iFTS queries
  • Implement language–aware, natural–language searches for data
  • Simplify searches of structured and unstructured content

Who this book is for

The audience for this book includes SQL Server, SQL and Transact–SQL developers, and also .NET developers, who want to take advantage of the integrated full–text search (iFTS) functionality available in SQL Server 2008.

Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.


If you think that you've found an error in this book, please let us know by emailing to editorial@apress.com . You will find any confirmed erratum below, so you can check if your concern has already been addressed.

On page 27:

You say that in Book_Content and Book_Name should be selected as column for the full text index but the 'Book_Name' does not exists?

Do you have an updated sql script providing the correct columns or is your book not describing the correct info?

On page 66:

Not an error but invalid results i.e. results don't match prints in book.

Returns 2 row in book but only returns one row in SQL

Query is correct

NOTE: This is not the first query where this is happening!!


    1. SQL Server T-SQL Recipes


      View Book

    2. Beginning SQL Server 2012 Administration


      View Book

    3. Building a Data Warehouse


      View Book

    4. Pro PowerShell for Amazon Web Services


      View Book