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 |
|
fisherman_jake
Slave to the Almighty Yak
159 Posts |
 Posted - 2002-01-23 : 19:45:49
|
Master gurus, G'day, I want to know if BEGIN TRANSACTION ... COMMIT TRANSACTION will be benefitial to my cause.. Basically I'm doing incremental DELETE/UPDATE/INSERT across 6 tables from a main table of about 137+million records.Thanks in advance.. I love my  ==================================================World War III is imminent, you know what that means... No Bag limits!!!Master Fisherman |
|
|
khalik
Constraint Violating Yak Guru
443 Posts |
Posted - 2002-01-23 : 21:00:23
|
| hi i think begin transaction and commit trans will helpful for small transaction but ur data is very big i am not sure sql will hold the amount of data.... do u need to rollback at any point of time. then it can be usefulltry to maintain small transaction....Ask to your self before u ask someone |
 |
|
|
|
|
|
Advantages of Begin Transaction