Never heard of it, have written hundreds of reports and no issues I am aware of.

Daniel Ratliff

From: [email protected] [mailto:[email protected]] On 
Behalf Of Robert Spinelli
Sent: Monday, March 02, 2015 9:29 AM
To: mssms
Subject: [mssms] Nolock on reports.

Having an internal debate in regards to writing reports for SCCM 2012 using / 
not using nolock.

Just wondering what others do?  Do you use nolock when writing queries/reports? 
 I've never used nolock, but others who are much better here at SQL said nolock 
should always be used.  They were surprised when I pointed out that none of the 
built in SCCM reports using nolock.

Thanks

Rob



The information transmitted is intended only for the person or entity to which 
it is addressed
and may contain CONFIDENTIAL material.  If you receive this 
material/information in error,
please contact the sender and delete or destroy the material/information.


Reply via email to