0
Why do we use with(nolock)?
3 Answers
+ 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
0
if u want see uncommitted transaction...
0
http://www.codeproject.com/Tips/590560/wi
this link will help