daca reusesc sa-mi dau seama cum fac rost de deadlock graph...da

astia sunt indexii care exista pe tabela respectiva....nu am cluster

CREATE NONCLUSTERED INDEX [iModifiedDate] ON [dbo].tbl1

[ModifiedDate] ASC

)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]

CREATE NONCLUSTERED INDEX [iStatusCode] ON [dbo].tbl1

[StatusCode] ASC

)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]

CREATE NONCLUSTERED INDEX [iTransactionCode] ON [dbo].tbl1

[TransactionCode] ASC

)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]

CREATE UNIQUE NONCLUSTERED INDEX [iUniq] ON [dbo].tbl1

[MessageCode] ASC

)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]

sunt cam 200.000 de inregistrari, 6 StatusCode distincte, in StatusCode = 1 intra inregistrarea propriu-zisa si apoi acest StatusCode trece prin toate cele 6 stari...prin update

multumesc.

alex.