GSquared,

Your explanation makes sense but when i am running

select top 10 * from table1

select top 10 * from table1

then for both queries, result set is same.

It's only when I put...

Mithilesh,

I tried a similar query. I do agree that NOLOCK gives uncommited data but very strangely when I was trying the queries, there was no other user/activity...so i dont expect...