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 ...
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 ...
When we try to extract information from a stack of data, we need tools to help us find what’s relevant and what’s important and to explore different scenarios. A report, whether printed on paper or ...