March 2006
Intermediate to advanced
640 pages
17h 8m
English
SQL-05: Keep transactions small
The larger the transaction, the more likely it is that the transaction will lock rows needed by another transaction, and the greater the chance that a deadlock might occur. Transactions should therefore usually be no larger than is absolutely necessary.