Why do we use with(nolock)?

Answer 1

if you use nolock in ur select statement, SQL will perform a dirty read of the table. SQL server will build a execution plan when ur trying to run a select statement and SQL server will use the best available plan. if u r using the nolock it will not use the best plan, since ur forcing the SQL server to use nolock

Answer 2

if u want see uncommitted transaction...

Answer 3

http://www.codeproject.com/Tips/590560/wi

this link will help