By popular request, the SQL Customer Advisory Team has collected our lessons learned about tuning data loading into a new whitepaper.We call it the “Data Loading Performance Guide” and you can find it on MDSN: http://msdn.microsoft.com/en-us/library/dd425070.aspx
In this paper, you can find all the tuning tricks we applied to achieve the ETL World Record and a full tuning methodology. We also provide a full overview of the bulk load methods and solutions to common data loading scenarios.
Happy data loading!
SQL Server Technical Article Published: January 2009 Writers: Thomas Kejser, Peter Carlin and Stuart