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 ...
Why Do We Need Olap Cube? For OLAP cubes to be truly effective, they must be able to deal with millions of records at the same time. OLAP cube queries can be done with plain English, in fact. Data ...