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