title: SQL Server 2008 Insert performance issue
body: <p>is there any way to increase performance of SQL server inserts, as you can see below i have used below sql 2005, 2008 and oracle. i am moving data from ORACLe to SQL.</p>
  
  <p>while inserting data to SQL i am using a procedure.</p>
  
  <p>insert to Oracles is very fast in compare to SQL, is there any way increase performance. or a better way to move data from Oracle to SQL (data size approx 100000 records an hour)</p>
  
  <p>please find below stats as i gathered, RUN1 and RUN2 time is in millisecond.</p>
  
  <p><a href="https://i.stack.imgur.com/Imvtr.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Imvtr.jpg" alt="http://tinypic.com/view.php?pic=23v19px&amp;s=5"></a>
  </p>