Really great script! I have a soluti

Written by Just Blindbæk. Posted in Comments

Really great script! I have a solution that runs 24/7 with users all around the world with new data coming in every 4 hours. Lets say i have daily partitions and monthly partitions. Once a month i will drop the daily partitions and create a new monthly partition. How do i prevent downtime? There would be some time between the dropping before the new partition is processed? In this time the cube is not displaying the right information. Can i wrap is all in a transaction in some sort of way? Or do i need to merge the partitions instead of drop/create? Regards Just