Pro Full-Text Search in SQL Server 2008

Front Cover
Apress, Dec 1, 2008 - Computers - 312 pages
2 Reviews

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

What people are saying - Write a review

We haven't found any reviews in the usual places.

Related books

About the author (2008)

Michael Coles has more than a decade's experience designing and administering SQL Server databases. A prolific writer of articles on all aspects of SQL Server, particularly on the expert use of T-SQL, he holds MCDBA and MCP certifications. He graduated magna cum laude with a bachelor of science degree in information technology from American Intercontinental University in Georgia. A member of the United States Army Reserve, he was activated for two years following 9/11.

Hilary Cotter has been involved in information technology for more than19 years. He has worked as a web and database consultant specializing in search solutions, and he has helped several major sites tune their e-commerce sites. Hilary has answered over 6,000 questions on the Microsoft newsgroups and founded, with Chris Crowe, both IISFAQ.com, the world's largest resource for information on Internet Information Server, and IndexServerFAQ.com, which averages 1.2 million hits per month. In 2001, Microsoft recognized him with a Microsoft SQL Server "Most Valuable Professional" award. Hilary received his bachelor's of applied science degree in mechanical engineering from the University of Toronto. He subsequently studied economics at the University of Calgary and computer science at the University of California, Berkeley.

Bibliographic information