title: SQL Server 2012 table lock on update command
body: <p>I have a table which contains above 2 millions records. When 50 users tries to update the same table SQL 1205 lock occurs and users have to wait for more then 20 seconds for update query which execute in milliseconds.</p>
  
  <p>It is a simple one table update query.</p>
  
  <p>I am using SQL Server 2012 and Asp.net MVC for server side </p>