Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: how to avoid deadlocks caused by delete/insert statments

    IX locks are at the page level. Moreover the Insert & delete statements always touches 2 different sets of data;

    below is the output of trace file;

    deadlock-list

    deadlock victim=process3c77d68

    process-list

    process id=process3c12c58 taskpriority=0 logused=1044...

Viewing post 1 (of 2 total)