© Dmitri Korotkevitch 2018
Dmitri KorotkevitchExpert SQL Server Transactions and Lockinghttps://doi.org/10.1007/978-1-4842-3957-5_11

11. Designing Transaction Strategies

Dmitri Korotkevitch1 
(1)
Land O Lakes, Florida, USA
 

A properly implemented transaction strategy would benefit every system. This chapter will provide a set of generic guidelines on the subject and discuss how you can improve concurrency in a system.

Transaction Strategy Design Considerations

Consistent transaction and error-handling strategies always benefit the system. They help to reduce blocking and simplify troubleshooting when blocking does occur.

As we already discussed in Chapter 2, the choice between client- and server-side transaction management greatly depends on the data ...

Get Expert SQL Server Transactions and Locking: Concurrency Internals for SQL Server Practitioners now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.