How many inserts can you have in a sql transaction.
Posted
by Mav
on Stack Overflow
See other posts from Stack Overflow
or by Mav
Published on 2010-05-28T00:19:24Z
Indexed on
2010/05/28
0:21 UTC
Read the original article
Hit count: 590
Filed under:
sql-server-2005
I have a task to do that will require me using a transaction to ensure that many inserts will be completed or the entire update rolled back.
I am concerned about the amount of data that needs to be inserted in this transaction and whether this will have a negative affect on the server.
We are looking at about 10,000 records in table1 and 60,0000 records into table2.
Is this safe to do in a single transaction?
© Stack Overflow or respective owner
