Category Archives: Index

Deadlock scenario: ALLOW_ROW_LOCKS and ALLOW_PAGE_LOCKS index options

Last month I helped one of my customer investigate a deadlock situation. After we got the deadlock report it turned out that we were dealing with a ‘conversion deadlock’ caused by inappropriate index options. Let’s reproduce and check the situation. … Continue reading

Posted in Deadlock, Index, SQL | 5 Comments