September 2010
Intermediate to advanced
1704 pages
111h 8m
English
SQL Server provides a number of hints that you can use in a query to override the default transaction isolation level:
• HOLDLOCK—HOLDLOCK maintains shared locks for the duration of the entire statement or for the entire transaction, if the statement is in a transaction. This option is equivalent to the Serializable Read isolation level. The following hypothetical example demonstrates the usage of the HOLDLOCK statement within a transaction:

As discussed earlier in this chapter, in the “Deadlocks” section, using HOLDLOCK in this manner leads to potential deadlocks between processes executing the transaction ...