• 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 a nolock hint as in queries below, the result set differs.

    select top 10 * from table1

    select top 10 * from table1 with (nolock)