A comparison of SQL Bulk insert methods

Using dot net and MSSQL/ADO.Net there are a variety of methods for inserting large amounts of data into SQL. These range from regular inserts to SQL Bulk copy. In this article I compare the performance of several bulk insert methods and some of the performance characteristics of these methods.