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:20 pm

    #993197

    Francis Rodrigues (5/12/2009)

    There are not any issues to my knowledge that require the NOLOCK hint for ROW_NUMBER(). I just used it for performance reasons.

    Thanks for the clarification. I guess that's what I was trying to get at. Do you mean that ROW_NUMBER() has such bad performance that you need to resort to using NOLOCK? Or is using NOLOCK just a common practice for your queries to try to preempt performance problems?

    Thanks.