SQL Server NOLOCK Hint

added by Richard Carr
4/16/2013 8:56:36 PM

4 Kicks, 544 Views

Where locking causes problems with queries it can be useful to execute those queries with the NOLOCK hint. This specifies that a query should ignore existing locks and create no data locks. However, the hint introduces the potential of data corruption.