Welcome to MSDN Blogs Sign in | Join | Help

News

  • Visit the SQL Server Best Practices site (http://sqlcat.com) for real-world guidelines, expert tips, and rock-solid guidance to take your SQL Server implementation to the next level.
Four new best practices articles are available

Four new best practices articles are available at the SQL Server Best Practices site on Technet (http://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
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/ssaspbpr.mspx
by Denny Lee, Nicholas Dritsas, Carl Rabeler

Analysis Services Query Performance Top 10 Best Practices
http://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
http://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
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/scoqryas.mspx
Denny Lee, Nicholas Dritsas

Posted: Tuesday, June 12, 2007 7:39 AM by denny.lee
Filed under:

Comments

binarymechanic said:

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

# July 2, 2007 7:49 PM
Anonymous comments are disabled
Page view tracker