In this chapter, we have discussed several topics:
- How to deploy changes to a database already in production, using Visual Studio configurations or the Deployment Wizard.
- Automating partition management using Integration Services and AMO code to create, merge, and delete partitions.
- Processing strategies. Although we always want to minimize the amount of time spent processing, there is no one processing strategy that is appropriate for all projects. In most cases, a Process Update will handle any updates to dimensions; this can then be followed by a Process Default on our partitions, which will rebuild any aggregations that have been invalidated by dimension processing on existing partitions, and fully process any newly created partitions. ...