SQLCAT.Com – eBook Downloads

As of September 1, 2013 we decided to remove SQLCAT.COM site and use MSDN as the primary vehicle to post new SQL Server content. This was done to minimize reader confusion and to streamline content publication.  MSDN SQLCAT blogs already includes most SQLCAT.COM Content and will continue to be updated with more SQLCAT learnings.  You can also… Read more

SQLCAT.com consolidated index of Whitepapers

In an effort to migrate as much content as possible from SQLCAT.com to the MSDN SQL CAT site we have consolidated all of the Whitepapers published over the last few years.   While all of the content actually exists on Technet and MSDN download sites, SQLCAT was a great resource to start looking.  Hopefully this will… Read more

New Best Practices Articles Published – Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques

Many-to-many dimension relationships in SQL Server 2005 Analysis Services (SSAS) enable you to easily model complex source schemas and provide great analytical capabilities. This capability frequently comes with a substantial cost in query performance due to the runtime join required by Analysis Services to resolve many-to-many queries. This best practices white paper discusses three many-to-many… Read more

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 discovered that they had two dimensions (each of which has >25 million members and 8-10 attributes) where… Read more

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 against their 110 GB cube took about 3 minutes.  When running both together, small… Read more

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. This white paper covers accuracy and precision considerations in SQL Server 2005 Analysis Services. For example, it is possible to query Analysis Services with similar queries and obtain… Read more

Process only one partition so you can browse the cube

If you want to browse the cube and validate dimensions, hierarchies and calculations using the data from only one partition, here is what you can do.  Deploy the new cube solution, run a process structure for the cube and then process only one of the partitions.  Process Structure will process all the dimensions plus mark… Read more

Using unformatted cell values it may improve query performance

If a report does not use formatted cell values, query time can be reduced.  An example is a Reporting Services report that does its own formatting and therefore would not use the formatted values from SSAS.  By returning only the value of the cell and not its formatted value in MDX, you can achieve better… Read more

SQL Server Best Practices Article: Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services

Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services There are a variety of things that you can do to improve the performance of an individual MDX query. To begin, you must identify the source(s) of the performance bottlenecks in the execution of a poorly performing MDX query. To identify the… Read more