Are missed rows and duplicate rows the symptoms due to allocation order scan or due to the no lock and page splits?

All we need is an easy explanation of the problem, so here it is. NOLOCK results in an allocation order scan rather than an index order scan. NOLOCK doesn't block…

Continue ReadingAre missed rows and duplicate rows the symptoms due to allocation order scan or due to the no lock and page splits?