Use of NOLOCK hint
NOLOCK hint is useful to improve the query performance when selecting the rowset from a table which is being accessed by multiple transaction.But this leads to dirty read.A dirty read is where a query reads data from the database without lock protection. Without lock protection, you cannot be guaranteed that the data isn’t changing during the time that the query is running.
3 comments:
Thank you for your information.
very nice post
dbakings
Nice post very helpful
dbakings
Post a Comment