Partitioned cubes and sparsity
When performance problems occur, one bottleneck is backing up the data on the hard drive. We can counter this by setting the saving policy. Depending on the selected setting, it is a trade-off between performance and security. With my suggestion I would like to defuse this tension. With the SQL-Server from Microsoft it is…