Chapter 10
Transactions and concurrency
This chapter covers transactions and their properties and describes how Microsoft SQL Server handles users who are concurrently trying to access the same data. I explain how SQL Server uses locks to isolate inconsistent data, how you can troubleshoot blocking situations, and how you can control the level of consistency when you’re querying data with isolation levels. This chapter also covers deadlocks and ways to mitigate their occurrence.
Because this is a book about fundamentals, this chapter focuses on concurrency aspects of traditional data representation in disk-based tables. SQL Server supports a memory-optimized database engine called In-Memory OLTP, which holds the data in memory-optimized tables. ...
Get T-SQL Fundamentals, 4th Edition 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.
