• AMJ-458987 (10/21/2009)When i use order by both the queries will give me same result set.

    Probably the rows in the dirty read wont be in the top 10 of your ordered results.

    As you have discovered nolock can be a very dangerous beast.

    Take a look at this link

    http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/11/10/1280.aspx



    Clear Sky SQL
    My Blog[/url]