Timeline for Can NOLOCK in a stored procedure be overridden when executing it?
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 29, 2013 at 13:37 | comment | added | James Jenkins | You have the 2008 R2 tag on your question, so I should point out, there does not seem to be any performance advantage to using the hint NOLOCK. stackoverflow.com/questions/15770402/… | |
| Aug 23, 2012 at 12:29 | history | migrated | from stackoverflow.com (revisions) | ||
| Aug 22, 2012 at 14:58 | comment | added | Calvin Fisher | Well, he got that 106k by offering his expertise and having the rest of us give him props for it. :) +1 and thanks to Remus as well. | |
| Aug 22, 2012 at 14:55 | vote | accept | Calvin Fisher | ||
| Aug 21, 2012 at 21:43 | answer | added | Aaron Bertrand | timeline score: 5 | |
| Aug 21, 2012 at 21:26 | comment | added | Remus Rusanu | No, you cannot. Short of pre-locking all tables involved to prevent any concurrent writes... | |
| Aug 21, 2012 at 21:17 | history | asked | Calvin Fisher | CC BY-SA 3.0 |