Query Hints

Question 1

With NOWAIT

Answer 1

QUERY WILL TIMEOUT IMMEDIATELY IF A LOCK EXISTS ON THE TABLE

Question 2

WITH PAGLOCKX

Answer 2

Statement will attempt to acquire an exclusive page lock instead of row or table locks

Question 3

WITH READPAST

Answer 3

Query will ignore locked rows and return a result set based on the unlocked rows

Question 4

WITH NOLOCK

Answer 4

Query will disregard any locks on the tables referenced by the query. This will result in DIRTY READS

Question 5

QUERY WILL TIMEOUT IMMEDIATELY IF A LOCK EXISTS ON THE TABLE

Answer 5

WITH NOWAIT

Question 6

Statement will attempt to acquire an exclusive page lock instead of row or table locks

Answer 6

WITH PAGLOCKX

Question 7

Query will ignore locked rows and return a result set based on the unlocked rows

Answer 7

WITH READPAST

Question 8

Query will disregard any locks on the tables referenced by the query. This will result in DIRTY

Answer 8

WITH NOLOCK

Question 9

WITH XLOCK

Answer 9

Place an EXCLUSIVE lock on the selected resources

Question 10

Place an EXCLUSIVE lock on the selected resources

Answer 10

WITH XLOCK