You are reading a single comment by @Velocio and its replies. Click here to read the full conversation.
  • Deleting / updating too much data in prod. Been there, done that :)
    After talking some more experienced devs, they did it too. But now I always wrap the whole thing in a transaction that rolls back immediately. Something like this:

    begin tran
     // select stuff before
     // do delete / update
     // run the same select to check and check number of rows affected
    rollback tran
    

    And re-run with commit if it's ok.

About

Avatar for Velocio @Velocio started