Post reply

DELETE running for 8 hours need to Stop the process

  • November 7, 2013 at 4:59 am

    #1664707

    chandan_jha18 (11/7/2013)

    sqlnaive (11/7/2013)

    it can do it fast enough plus doing it this way controls your CPU else delete operation is just nasty.

    its also perfect way to manage the log size.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • November 7, 2013 at 5:20 am

    #1664712

    chandan_jha18 (11/7/2013)

    sqlnaive (11/7/2013)

    Interesting read. Gives the pretty much idea on what you can end up into if not consider the impact of the DML.

    Burned my hands with heavy deletes once, so always performed this operation in batches thereafter so that even if it had to rollback for whatever reason, it can do it fast enough plus doing it this way controls your CPU else delete operation is just nasty.

    Cheers!!

    Chandan

    Totally agreed. In between, also there should be a proper way to write your DML commands in a way that under any case you not accidentally press "F5" without selecting "WHERE" condition. I have seen one of my friend doing it accidentally after which he changed his way of writing code.

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply