Viewing 3 posts - 1 through 3 (of 3 total)
Will the transaction log process each loop? I'm not understanding how programs (scripts) work as I've been told to put GO statements in to make sure the previous commands are...
August 5, 2018 at 3:44 pm
Thanks for all the help. I have observed that when I delete several months of data, about 500 mb worth, the transaction log increases from 200 mb to...
August 4, 2018 at 2:46 am
In the Simple recovery model, the transactions are supposed to disappear as soon as the delete is done, right? So there is no rollback unless power fails before the delete...
August 3, 2018 at 8:37 pm