Update: Added the link back in as it got lost somehow

Some good posts already , I like the one about bulk loading, one of the most misunderstood areas of SQL Server in reality. Probably ripe for an FAQ or a Mythbuster...