Interview Questions
1. Explain the NOLOCK optimizer hint and some pros\cons of using the hint?
The NOLOCK query hint allows SQL Server to ignore the normal locks that are placed and held for a transaction allowing the
query to complete without having to wait for the first transaction to finish and therefore release the locks. This is one short
term fix to help prevent locking, blocking or deadlocks. However, when the NOLOCK hint is used, dirty data is read which can
compromise the results returned to the user.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment