Home Forums SQL Server 2008 SQL Server 2008 - General Remove blocking due to LCK_M_S and LCK_M_U RE: Remove blocking due to LCK_M_S and LCK_M_U

  • December 20, 2012 at 10:11 am

    #1570605

    Would this help?

    WAITFOR DELAY '00:00:00.05' -- Wait for 5 ms

    And also if there are 6 threads spanning 70k records, will table partitioning be of help?