--Query the table that is being locked by our update
--without (nolock) hint. It is waiting for another process to release the lock

select * from Employee 


--Query the table that is being locked by our update
--with  a (nolock) hint, which can give back uncommited data (Dirty Read)

select * from Employee (nolock)