• Fair enough, it was just that I seem to remember some reference to (nolock) dealing with potentially non-commited data and the obvious impacts of that might not be that desirable.

    Seems like we are both asking for more detail/history from the originator.

    Delete of 11 million rows doesn't sound like a daily task to me, but I might be wrong!!