SQL Server

SQL Server

Partitioning relational and multidimensional data for OLAP solution – (Part-2)

Partitioning relational and multidimensional data for OLAP solution – (Part-2) Multidimensional solutions usually hold extremely large amounts of data. Partitioning this data can improve manageability because aged data can be removed more easily. When aged data is removed from the relational data source, the matching partition can be removed, so it is not necessary to reprocess the entire cube. Well-designed […]