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-06-12 : 09:54:43
|
| Artika writes "insert into tbl_destination select Col1, Col2, Col3, Col4, Col5, from tbl_Sourcetbl_Source has 40 Million records.Q. I would like to break down the insert process into small rowsets... lets say 5,000 or 10,000 so that a commit can happen which in turn doesn;t create a humgous transaction log file. My main concern is the consumption of disk space when this query is run.i could use a cursor, but from what i am told , this may be a resource hog.any suggesstions to make this bulk copy operation efficient and not make my transaction log 14 GB?" |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2006-06-14 : 08:19:58
|
| BCP!------------------------I think, therefore I am - Rene Descartes |
 |
|
|
|
|
|
Table to table copy ( in predetermined row chunks)