Data Partitioning is a very useful feature in SQL Server 2005 and beyond. I have discussed this database feature in previous blog entries but it is also available in SQL Server Analysis Services which ...
There are some basic rules of thumb that can be applied to assist in this determination. But first it helps to look at the greater picture of OLAP compared to ROLAP. The ‘traditional’ OLAP engine ...