Locking and blocking are fundamental to any database to maintain consistency. In this paper we will try to look at the various ways to identify potential problems of locking / blocking, how they are different, what are the options SQL Server gives to resolve the same and more.