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.

October 2007 - Posts

Using ByAttribute or ByTable Processing Group Property with Analysis Services 2005
As noted within the Analysis Services 2005 Performance Guide , there are some niche situations where setting the Processing Group property to ByTable provides more optimal processing than the default value of ByAttribute. In a customer scenario, we had Read More...
Posted: Friday, October 19, 2007 9:19 PM by denny.lee | 2 Comments
Filed under: , ,
SSAS small/big query interaction
Default SSAS behavior can sometimes result in small queries being slowed down by concurrently running big queries. Recently in working with a customer, we observed the most common queries when run by themselves took about 1 second and some ad-hoc queries Read More...
Posted: Friday, October 19, 2007 5:24 PM by Eric Jacobsen | 2 Comments
Filed under: , , ,
Precision Considerations for Analysis Services Users Whitepaper now available
For those of you whom want to know a little more about precision considerations for Analysis Services users, please check out this recently released whitepaper at http://www.microsoft.com/downloads/details.aspx?familyid=bae8beec-9892-4ecd-a9db-292254895f9c&displaylang=en Read More...
Posted: Tuesday, October 09, 2007 10:28 PM by denny.lee | 1 Comments
Filed under: , ,
Page view tracker