• Why do you think partitioning will help?

    Have you confirmed the problem is locking? If so, what kind of locks from what operation?

    Have you pinpointed exactly where in the process the problem is occuring?

    Get the book I recommended, do some basic troubleshooting, identify the cause of the problem. Once you know exactly what is causing the problem, it's possible to make a proper recommendation as to a solution.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass