tag:blogger.com,1999:blog-213131476646021708.post5662673865063567274..comments2023-06-28T12:23:57.400+02:00Comments on SQL Server Online: Non Clustered Indexes may prevent dead locksHolger Schmelinghttp://www.blogger.com/profile/09685478805011670145noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-213131476646021708.post-21876469451775038862011-07-23T11:11:34.151+02:002011-07-23T11:11:34.151+02:00Dadlocks can occur because of a diversity of cause...Dadlocks can occur because of a diversity of causes and on many ressources. I didn'd say that NCI will prevent any deadlock. It's just one approach that might be appropriate.Holger Schmelinghttps://www.blogger.com/profile/09685478805011670145noreply@blogger.comtag:blogger.com,1999:blog-213131476646021708.post-2829638775024661102011-07-20T14:38:07.045+02:002011-07-20T14:38:07.045+02:00We have similar execution plans taking many concur...We have similar execution plans taking many concurrent updates and all use non-clustered index seeks at the beginning. So, why do we still see deadlocks?ipad 2 dockhttp://ipad2dock.netnoreply@blogger.com