SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED NO LOCK

Everyone undergoes a blocking or locking issues when one forgets to write
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED NO LOCK or what ever...

In order to avoid such situation and which can also save a lot of time, you can setup READ UNCOMMITTED Option From SSMS>Tools>Options> Query Execution SQL Server> Advanced as shown below. also there is whole bunch of options available where you can play with .. 

Setting up Isolation Level