• Nice article, I dont see the problem, as others have posted links to blogs etc.

    In regards to the actual blog, it rings a few bells with something I'm seeing in project im currently 'tuning', there are at times a number of large deletes being run and im not sure they use the TABLOCK hint.

    time to check to see if this could be causing this project an issue.

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices