title: Fastest way to bulk insert rows into sql server
body: <p>Via a web service, remote computers will be sending a set of rows to insert into our central sql server.</p>
  
  <p>What is the best way (performance wise) to insert these rows?  There could be anywhere from 50-500 rows to insert each time.</p>
  
  <p>I know I can do a bulk insert or format the data as XML that insert it that way, but I've never done this in an enterprise setting before. </p>
  
  <p><b>Updates</b>
  using wcf web services (or maybe wse not sure yet) and SQL Server 2008 standard.</p>