Home Forums Article Discussions Article Discussions by Author Discuss content posted by Francis Rodrigues ROW_NUMBER(): An Efficient Alternative to Subqueries RE: ROW_NUMBER(): An Efficient Alternative to Subqueries

  • May 12, 2009 at 12:19 pm

    #993195

    JJ B (5/12/2009)

    Well done article.

    Question: I hate to open a can of worms on a different topic, but I'm so curious as to why you specified the nolock hint for the row_number version of the query. Do you know of specific problems that require use of nolock for this type of implementation?

    Thanks.

    There aren't any problems with the ROW_NUMBER() version of the query that require the NOLOCK hint. I just used it for the slight performance improvement.