subbareddy542 (1/24/2013)
adv of nolock it is removing dead lock.for live data nolock option don't use.
if you normailly not live data that time nolock will more useful.
this is probably the immatured information .
see this link http://www.mssqltips.com/sqlservertip/2470/understanding-the-sql-server-nolock-hint/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)