Shrinking a SQL Server database
What is the best way to shrink a database? What are the alternative methods?

Answer Question   |  July 6, 2009  4:57 PM
SQL Server database, SQL Server Database Consolidation, SQL Server databases

Storing large data files in SQL Server
What are the alternatives to store data more than 2 GB in SQL Server 2005 or 2008?

Answer Question   |  January 22, 2009  6:13 PM
SQL Server 2005, SQL Server 2008, SQL Server Data Storage, SQL Server Database Consolidation

Consolidating SQL Server databases
How I can consolidate seven SQL Server 2000 and SQL Server 2005 databases to only SQL Server 2005 databases? Both servers are HP and Dell servers.

Answer Question   |  December 10, 2008  9:09 PM
SQL Server 2000, SQL Server 2005, SQL Server Database Consolidation, SQL Server databases

How to consolidate databases from different SQL Server versions to one SQL Server 2005 database
We have 52 SQL Server databases on different SQL Server versions (6.5,7.0,2000). We need to consolidate all the databases into a single SQL Server 2005 database. The structure is almost the same for all the databases, i.e.,tables/datatype. The actual data is different in all the databases. Could you please provide advice or links to documents [...]

Answer Question   |  April 29, 2008  3:45 PM
SQL Server Database Consolidation, SQL Server upgrades