Partilhar via

Four new best practices articles are available

  • Artigo

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