SQL Server 2005 – How To Move 10 Millions Rows In 1 Millisecond, by Adam Haines

Worth to read... http://jahaines.blogspot.com/2009/12/sql-server-2005-how-to-move-10-millions.html