SQL Server 2008 Insert performance issue
- by mithiya
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.