Hi all,

I have a related question that I think was somehow answered in the above posts but I just wanted clarification for academic purposes:

Suppose I change a field of data from Table-1 from "Some Data Before" to "Some Data After".

Now suppose that this is not committed but due to memory pressure or some other reason there's a checkpoint and it's written from the log cache to the disk (.Ldf), and also from data cache to the disk (.mdf).

Now I want to do a Select with "read uncommitted" (I'm not fully sure but I think this is done using "With (NoLock)"??).

From where does my Select statement fetch the "Some Data Before"? Does it, seeing the With(Nolock), divert the request to the .ldf data and step back to the last committed value of that particular row?

Thanks,

Jim