A comparison of SQL Bulk insert methods

added by lukemcgregor
8/23/2012 5:30:22 AM

0 Kicks, 45 Views

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.