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
About dineshasanka
I have more than 15 years of experience in ICT inductry out of which 10 years in the SQL Server Database developments and designing.
These days more focus on BI / Datawhare house stuff in SQL Server