Advertisement

Pro Full-Text Search in SQL Server 2008

  • Authors
  • Michael Coles
  • Hilary Cotter

Table of contents

  1. Front Matter
    Pages i-xxiii
  2. Pages 19-43
  3. Pages 75-97
  4. Pages 99-118
  5. Pages 119-144
  6. Pages 145-164
  7. Pages 165-183
  8. Pages 207-237
  9. Back Matter
    Pages 257-287

About this book

Introduction

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

Keywords

Microsoft SQL Server SQL SQL Server 2008 computer database performance

Bibliographic information