-- can't read from Address while tranasction open in other process
select * from Address where StudentId=1
-- only the "page" is locked, other pages may be availble
select * from Address where addressid = 10000
-- can do a dirty read
select * from Address with (nolock) where StudentId=1
-- initiate a deadlock
set Street1 = 'W725 Haeussinger Rd'