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 |
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
 Posted - 2011-01-21 : 14:29:24
|
| Hi all,I need to insert large volume of records into an table. It takes more time to insert the records serially.. Is it possible to insert the records parallely in Database? If so, how to do it.. what are the settings required and procedure to do it. kindly let me know all these.. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2011-01-21 : 14:32:46
|
The difference between inserting 1 chunk of 10,000,000 records or inserting 100 chunks of 100,000 records is huge in terms of log file pressure.And if you with "serially" mean to do 10,000,000 inserted of 1 record your are not thinking set-based at all.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-01-21 : 19:14:38
|
It sounds actually like he is currently inserting 1 at a time instead of a bulk insert...but the log file pressure and chunks is a key point to consider.You want us to provide you with code, settings and procedure to do something, but we have absolutely zero information to help. Where is the source? what is the destination? how many columns? one time only or a recurring job?
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-01-24 : 10:44:43
|
| at least show what your current insert proc is to atleast understand how you're doing currently------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Parallel DML PROCESS