dcsimg
Results 1 to 2 of 2

Thread: Nolock

  1. #1
    Join Date
    Dec 2006
    Location
    Portland, Oregon
    Posts
    64

    Question Nolock

    [This thread is associated with Part 7 of the SqlCredit series]

    What do you think about the NOLOCK arguments? Check out the references at the end of the article for background reading.
    Last edited by rgarrison; 07-27-2007 at 11:09 AM. Reason: Removed "to be published"

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,909
    The missing rows in SELECT was news to me.

    I would not mind using NOLOCK on lookup table queries where there are minimum changes, but then there might not be a need to use NOLOCK on them anyways.

    But for Credit application, where data integrity is so crucial, NOLOCK is NO WAY.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •