• Bhuvnesh (11/6/2013)


    Tej_7342 (11/5/2013)


    There are 2.2 billion records in the table and we want to only keep 2 weeks data, as of now we are lagging behind so we want to delete data in smaller chunks first so that the logs don't get messed up.

    you should look for batch approach for these type of deletions

    see http://www.sqlservercentral.com/articles/Top/63301/

    And indexing 😉