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