SQL Server Customer Advisory Team - SQL Server Best Practices

Enabling SQL Server customers to navigate the most challenging frontiers of large scale data management.

Whitepapers

SQL Server 2005 Full-Text Queries on Large Catalogs: Lessons Learned

Published: June 11, 2007

Writer: Ron Talmage, Solid Quality Learning

Technical Reviewers: Prem Mehra, Jingwei Lu, James Podgorski, Sanjay Mishra

The observations in this paper are based on tests run in the SQL Server Customer Lab for a customer who needed to scale up full-text search to a much greater potential volume. The paper describes the customer scenario, provides an overview of SQL Server 2005 full-text concepts that bear on the results, and offers lessons learned and recommendations for using full-text queries on large catalogs.

Included in this whitepaper:

Introduction
Customer scenarios
About SQL Server Full-Text Search
Recommendations
Conclusion

Link to this whitepaper: SQL Server 2005 Full-Text Queries on Large Catalogs: Lessons Learned

Published Nov 21 2007, 01:42 PM by Lindsey.allen

Filed under: Scalability, Optimization, Full-Text

Comments

No Comments

About Lindsey.allen

Lindsey Allen has been working with SQL Server and Business Intelligence for the past 15+ years. She joint Microsoft Consulting Services summer of 1995 and transitioned to SQL Server Product Group summer of 2005. Lindsey is currently managing SQLCAT Best Practice and Customer Lab team.