Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-11-16 : 09:50:42
|
| Amit writes "Hi,I am trying to move bulk data from one table to anothar. Number of rows inserted or moved are upto 10 million in some tables. I am using SQL Server 2000 and I wondored if there is a way if I could somehow tell SQL server to commit data in smaller chunks like 20000 rows or 100000 rows at a time.My main concern here is to reduce the time taken. I have used many ways to do that, like using indexes on source system, removing them in the destination table etc and reduced the time taken considerably. I wondored if I could still improve the performance by breaking the data to commit in chunks rather than one whole big transaction. I want to avoid writing custom code for doing the same but if I have to then I probably will.I hope someone has some cool ideas for doing this.Thanks in advance.Amit" |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Can I specify the dataset commit size in a bulk insert 