1 Answers

1. 

   use of WITH (NOLOCK) in SQL Server Ankit Kumar

   9/1/2018 9:47:16 AM

   The NOLOCK hint allows SQL to read data from tables by ignoring any locks and therefore not being blocked by other processes.

   This can improve query performance, but also introduces the possibility of dirty reads.

   Read more to better understand the use of NOLOCK.

    

   BEGIN TRANSACTION 
   UPDATE Customer set Contact='0004894149' where ID=1

    

   If you run the above query ,you will notice that it never completes, because the UPDATE has not yet been committed.   

   select * from customer where ID=1

   If we run above SELECT without NOLOCK  in another query window then your table will getting locked.

            

   select * from customer with(nolock)where ID=1

   If we run above SELECT with NOLOCK  in another query window then your table will return all record.