title: Fastest way to insert in parallel to a single table
body: <p>My company is cursed by a symbiotic partnership turned parasitic.  To get our data from the parasite, we have to use a painfully slow odbc connection.  I did notice recently though that I can get more throughput by running queries in parallel (even on the same table).</p>
  
  <p>There is a particularly large table that I want to extract data from and move it into our local table.  Running queries in parallel I can get data faster, but I also imagine that this could cause issues with trying to write data from multiple queries into the same table at once.</p>
  
  <p>What advice can you give me on how to best handle this situation so that I can take advantage of the increased speed of using queries in parallel?</p>
  
  <p>EDIT:  I've gotten some great feedback here, but I think I wasn't completely clear on the fact that I'm pulling data via a linked server (which uses the odbc drivers).  In other words that means I can run normal INSERT statements and I believe that would provide better performance than either SqlBulkCopy or BULK INSERT (actually, I don't believe BULK INSERT would even be an option).</p>