SQLServerCentral » Latest topics
Help in analyzing deadlock and index recommendation - all definitions included
Hi,
There is a procedure and a trigger that are involved in deadlock.
The table had no indexes or primary keys. I created a non-clustered index on EmailAddress when the deadlock started to occur.
That index somewhat reduced the deadlock o
There is a procedure and a trigger that are involved in deadlock.
The table had no indexes or primary keys. I created a non-clustered index on EmailAddress when the deadlock started to occur.
That index somewhat reduced the deadlock o
No comments:
Post a Comment