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
sql-server
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.
© Stack Overflow or respective owner