Selasa, 15 Februari 2011
What should be considered when NOLOCK hint is used
IntroductionWith SQL Server the NOLOCK hint is very tempting especially with SELECT statements where at least one of the tables is frequently updated. Using the NOLOCK removes all queueing problems and the SELECT statement runs smoothly, but not without side effetcs. Why do we need a hint at allFirst question might be that why do we need to add this hint to get the statement running without
Langganan:
Posting Komentar (Atom)
Tidak ada komentar:
Posting Komentar