June 9, 2011 at 11:20 am
June 9, 2011 at 11:55 am
clare.xia (6/9/2011)
"Now back to the question. The nolock is not 100% guaranteed, if there are inserts updates affecting that exact row, or other memory resource issues, and sometimes a clustered index you could have some issues. I would also check to see if you have enough free memory on the server, in laments terms nolock says give me what pages you have in memory for this record. If there is not enough FREE memory then SQL cannot page(store) it in memory and in that case Nolock will not help you at all because it must read from Disk and thus fight with the records being affected."I have some confusion about the above statement.. Could anyone elaborate more on this?
Don't worry about it. It's pretty close to 100% incorrect.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 31 through 31 (of 31 total)
You must be logged in to reply to this topic. Login to reply