Will SQL Server NOLOCK prompt return partially written strings?

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.

+3
source share
2 answers

. , , , . , SELECT, . .

+6

, . NOLOCK , . , , sql , , .

, , , , - , .

+3

Source: https://habr.com/ru/post/1719130/


All Articles