Pro Full-Text Search in SQL Server 2008

by Michael Coles (Author), Michael Coles (Author), Hillary Cotter (Contributor)

• New

  Illustrated
  2010

  $38.56

  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