SSAS Tips 
Split large partitions, with more than 20 million rows or that are over 250 MB in size, into ...
Split large partitions, with more than 20 million rows or that are over 250 MB in size, into ... | Split large partitions, with more than 20 million rows or that are over 250 MB in size, into ... |
| Thursday, 21 June 2007 19:38 | ||||
|
Split large partitions, with more than 20 million rows or that are over 250 MB in size, into smaller partitions to improve performance. Importance - Medium. Source - SSAS 2008 (Katmai) June CTP Partition and Aggregation design warning rules.
|
||||
Top Rated
- Do not ignore duplicate key errors. Change the KeyDuplicate property of the error configuration ...
- Avoid redundant attribute relationships because these relationships may prevent data from being ...
- Avoid having 10 or more dimensions with a single attribute. Consider unifying them
- If you can, list in SELECT statement real measures first and calculated measures after
- Remove aggregation designs that are not used by any partitions
- Process only one partition so you can browse the cube
- NULL default measure might improve querying performance
- Create hierarchies in non-parent child dimensions
