EnterBangla.BlogSpot.com
Posted: February 15th, 2009, 7:35pm CET by NakedExposer
Que:- What is a NOLOCK? Ans:- Using the NOLOCK query optimiser hint is generally considered good practice in order to improve concurrency on a busy system. When the NOLOCK hint is included in a SELECT statement, no locks are taken when data is read. The result is a Dirty Read, which means that another process could be updating the data at the exact time you are reading it. There are no guarantees