Moving a Cube Partition Without Unprocessing It
Last week I spent some time redesigning a SSAS multidimensional cube and part of that effort involved re-partitioning the measure group by customer (instead of date) and redistributing the partitions across a new set of drives. Initial testing shows serious performance improvement (which I plan to blog about in a bit more detail in the next few weeks) but today I wanted to focus on a neat trick that helped me recover from a minor boo-boo when getting through the validation tests.
Read more...Tags: management