SQL Server 2008 Insert performance issue

Posted by mithiya on Stack Overflow See other posts from Stack Overflow or by mithiya
Published on 2010-05-10T10:04:36Z Indexed on 2010/05/10 10:14 UTC
Read the original article Hit count: 253

Filed under:

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.

while inserting data to SQL i am using a procedure.

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)

please find below stats as i gathered, RUN1 and RUN2 time is in millisecond.

http://tinypic.com/view.php?pic=23v19px&s=5

© Stack Overflow or respective owner

Related posts about sql-server