Why do we use with(nolock)?

12th Jul 2016, 5:25 AM
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
14th Jul 2016, 6:35 PM
Tijo Joseph
Tijo Joseph - avatar
if u want see uncommitted transaction...
12th Jul 2016, 7:17 AM
srinivas T
srinivas T - avatar
21st Jul 2016, 7:59 PM
ashwath nm
ashwath nm - avatar