Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Four new best practices articles are available at the SQL Server Best Practices site on Technet (https://technet.microsoft.com/en-us/sqlserver/bb331794.aspx).
Two of the articles are on Analysis Services Processing and Querying best practices:
Analysis Services Processing Best Practices
https://www.microsoft.com/technet/prodtechnol/sql/bestpractice/ssaspbpr.mspx
by Denny Lee, Nicholas Dritsas, Carl Rabeler
Analysis Services Query Performance Top 10 Best Practices
https://www.microsoft.com/technet/prodtechnol/sql/bestpractice/ssasqptb.mspx
by Carl Rabeler
For those of you interested in Full-text Queries on large catalogs, a great paper is
SQL Server 2005 Full-Text Queries on Large Catalogs: Lessons Learned
https://www.microsoft.com/technet/prodtechnol/sql/bestpractice/ftslesld.mspx
by Ron Talmage
As well, for guidance on building a Scale Out Querying for Analysis Services, please refer to:
Scale-Out Querying with Analysis Services
https://www.microsoft.com/technet/prodtechnol/sql/bestpractice/scoqryas.mspx
Denny Lee, Nicholas Dritsas
Comments
- Anonymous
July 02, 2007
I wish that sp_fulltext_querytimeout was documented in a place other than a best practice. I appreciate the Best Practices, but the things they outline should already be well documented (IMHO).