It's not really for performance as much as concurrency. If you find you are querying this data quite often (and it is very large, like in the 10s of millions or +), you might look into caching resultsets and querying the cache instead.
David L. Penton, Microsoft MVP JCPenney Technical Specialist / Lead "Mathematics is music for the mind, and Music is Mathematics for the Soul. - J.S. Bach" [EMAIL PROTECTED] Do you have the VBScript Docs or SQL BOL installed? If not, why not? VBScript Docs: http://www.davidpenton.com/vbscript SQL BOL: http://www.davidpenton.com/sqlbol -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Robert Hinojosa How often do you all use (NOLOCK) in your SQL queries when doing a select? How much of a performance gain do you really gain when doing a select statement of large tables? I've been starting to use it more and more, but performance hasn't really increased much, and I'm just wondering what kinds of experiences you all have had. Robert ------------------------------------------------------------------------- This email server is running an evaluation copy of the MailShield anti- spam software. Please contact your email administrator if you have any questions about this message. MailShield product info: www.mailshield.com ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
