Pro Full-Text Search in SQL Server 2008

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 ofiFTS 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.