O'Reilly logo
  • Marshall Pettit thinks this is interesting:

Microsoft recommends that you use a staging database during incremental loads to reduce table fragmentation. When you use a staging database, the data is first loaded into a temporary table in the staging database before it is inserted into the permanent table in the destination database.


Cover of SQL Server Integration Services Design Patterns, Second Edition


Here's good use of the 1.6 TB PCI card.