It means what i am getting dirty or uncommitted records from second query (select top 10 * from Table1 With(NOLOCK).

Actually i am confused because of order by clause. When i use order by both the queries will give me same result set.

Reason why i am stuck in this situation is that we are improving the performance of our application using WITH (NOLOCK). During this process i got two different result set from the similar queries .

My question is that will it affect my work or not? If i get two different result sets.

Or it is better not to use WITH (NOLOCK) in select statement.