Pro Full-Text Search in SQL Server 2008

Businesses today want actionable insights into their datathey want their data to reveal itself to them in a natural and userfriendly form. What could be more natural than human language? Naturallanguage search is at the center of a storm of everincreasing webdriven demand for humancomputer communication and information access. SQL Server 2008 provides the tools to take advantage of the features of its builtin enterpriselevel naturallanguage search engine in the form of integrated fulltext search (iFTS). iFTS uses textaware relational queries to provide your users with fast access to content. Whether you want to set up an enterprisewide Internet or intranet search engine or create less ambitious naturallanguage 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 fulltext query performance through features like fulltext indexes and iFilters
• Providing examples that help you understand and apply the power of iFTS in your daily projects

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

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