title: SQL deadlock while attempting IX lock on page
body: <p><img src="https://i.stack.imgur.com/AepAA.jpg" alt=""></p>
  
  <p>I can't understand why this deadlock is occuring.
  The transaction on the right affects (updates) only one row, it looks like so:</p>
  
  <pre><code>update table1
  set column1 = 'value1'
  where key1 = 1
  </code></pre>
  
  <p>I assume the IX request is for the page where the row (that is being updated) is located, right? But that cannot be, because there's a shared lock on this page. Or is the IX request for some other page?</p>
  
  <p>Also is it possible to prevent the IX lock (maybe some hint)? Because I know that I'm updating only ONE row and there's no intent to update anything else in this transaction.</p>
  
  <p><strong>UPDATED:</strong></p>
  
  <p>Table1 - consists of five columns (renamed) and a primary key:</p>
  
  <pre><code>CREATE TABLE [dbo].[Table1](
      [Key1] [int] IDENTITY(1,1) NOT NULL,
      [Column1] [nvarchar](50) NOT NULL,
      [Column2] [int] NOT NULL,
      [Column3] [nvarchar](50) NULL,
      [Column4] [int] NOT NULL,
      constraint PK_Key1 primary key([Key1])
  )
  </code></pre>
  
  <p>The other transaction consists of one single select statement that contains a lot of joined tables, inluding Table1 - for security reasons I cannot divulge it here.</p>