Change the index on the transaction_id from none clustered to clustered solve the problem, but i dont know to explain how.

How actions on different rows cause to deadlock?

Why the...

Sorry for not beeing clear.

There are two iis servers that executing in parallel multiple request.

each request work on its own retail-transaction, means on specific row in the table, so there...

One of the column in the table is blob, so each row store big data and can be bigger than page , if this help is something.

CREATE TABLE [dbo].[TRN_RETAIL_TRANSACTION_TAB](

[TRANSCTION_ID] [int] IDENTITY(1,1) NOT NULL,

[RETAIL_TRANSACTION] [varbinary](max) NULL,

[UPDATED_DATE] [datetime] NOT NULL,

[UPDATED_STORE_ID] [int] NULL,

[UPDATED_POS_ID] [int] NULL,

[IS_CLOSED] [bit] NOT NULL DEFAULT ((0)),

[IS_SUSPENDED] [bit] NOT NULL DEFAULT ((0)),

[SEQUENCE_NUMBER] [int] NOT NULL DEFAULT...