Pro Full-Text Search in SQL Server 2008, Hilary Cotter; Michael Coles

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