A Guide to Consolidating SQL Server Data Warehouses

onsolidation of SQL Server instances and databases has become a common practice over the past few years. In most environments, this consolidation focuses on application-based databases that generally support OLTP workloads.
More at http://bidataware.blogspot.com/2009/11/guide-to-consolidating-sql-server-data.html