Viewing 6 posts - 1 through 7 (of 7 total)
george sibbald (2/7/2009)
February 7, 2009 at 3:03 pm
Lynn Pettis (2/7/2009)
There are also changes to any indexes that need to be logged in case of a rollback.
Thanks. Yes, this might be the case. I will drop them...
February 7, 2009 at 2:02 pm
In your statement there is no commit statement
I don't have any "begin transaction" statement.
...and the log grows as it has to hold all deleted rows
The size of all...
February 7, 2009 at 1:11 pm
Yes.
My question is still: if I delete 240MB data, why does the transaction log grow by 15GB?
February 7, 2009 at 12:48 pm
I delete the rows in a single go: "DELETE T1 WHERE T2ID=NN"
So, you are saying that the transaction log will not increase its size as much if I delete the...
February 7, 2009 at 12:24 pm
The question was: Why does the transaction log grow by 15GB when the deleted data is only 240MB.
Cheers//Jonas
February 7, 2009 at 12:02 pm
Viewing 6 posts - 1 through 7 (of 7 total)