First of all, I am not asking whether to use or not to use NOLOCK. Let it pass.
I think the question boils down to how sql server writes data? Is the entire row written at once or does it write columns at a time?
I ask because the NOLOCK hint is being considered. A dirty read is OK until the entire line is returned (or not returned). Partially written lines are not acceptable.
user183305
source
share