SQL NOLOCK
SQL NOLOCK is a record locking hint used in SQL Queries. In one instance one of our users told us he experienced record locking problems while running DynamicZip Tax Reports using the SQL Optimized option. At his request we added the SQL NOLOCK option which utilizes this hint in certain SQL Queries used to generate the related report.
Our own research on this subject suggests that this option should be used only if you experience record locking problems and then should be used with the understanding that the resulting reports may lack the accuracy and precision that they would have without the option.
Subsequent testing by the above mentioned user indicated that SQL NOLOCK did not resolve the problem he was experiencing. As a result, we have since removed this option.