Kniha momentálne nie je na sklade
Viac o knihe
Focusing on SQL Server concurrency, this book delves into the critical role of transactions and their ACID properties in managing multiple processes accessing data simultaneously. It explores transaction isolation levels, contrasting pessimistic concurrency—which uses locks—with optimistic concurrency that employs row versioning. Detailed explanations of different locks, control mechanisms, and troubleshooting techniques for blocking and deadlocking are provided. The author emphasizes the necessity for DBAs and developers to grasp these concepts for optimal data access and performance.
Nákup knihy
SQL Server Concurrency, Kalen Delaney
- Jazyk
- Rok vydania
- 2012
- product-detail.submit-box.info.binding
- (mäkká)
Akonáhle sa objaví, pošleme vám e-mail.
Doručenie
Platobné metódy
Navrhnúť zmenu
- Titul
- SQL Server Concurrency
- Jazyk
- anglicky
- Autori
- Kalen Delaney
- Vydavateľ
- Red Gate Books
- Rok vydania
- 2012
- Väzba
- mäkká
- Počet strán
- 202
- ISBN13
- 9781906434915
- Kategórie
- Počítače, IT, programovanie
- Anotácia
- Focusing on SQL Server concurrency, this book delves into the critical role of transactions and their ACID properties in managing multiple processes accessing data simultaneously. It explores transaction isolation levels, contrasting pessimistic concurrency—which uses locks—with optimistic concurrency that employs row versioning. Detailed explanations of different locks, control mechanisms, and troubleshooting techniques for blocking and deadlocking are provided. The author emphasizes the necessity for DBAs and developers to grasp these concepts for optimal data access and performance.