Query Hints Flashcards Preview

70-464 Certification > Query Hints > Flashcards

Flashcards in Query Hints Deck (10)
Loading flashcards...
1

With NOWAIT

QUERY WILL TIMEOUT IMMEDIATELY IF A LOCK EXISTS ON THE TABLE

2

WITH PAGLOCKX

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

3

WITH READPAST

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

4

WITH NOLOCK

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

5

QUERY WILL TIMEOUT IMMEDIATELY IF A LOCK EXISTS ON THE TABLE

WITH NOWAIT

6

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

WITH PAGLOCKX

7

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

WITH READPAST

8

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

WITH NOLOCK

9

WITH XLOCK

Place an EXCLUSIVE lock on the selected resources

10

Place an EXCLUSIVE lock on the selected resources

WITH XLOCK