Are You Optimistic About Concurrency?

Explore the intricacies of concurrency in SQL Server with renowned expert Kalen Delaney in this comprehensive conference talk from PASS Summit 2014. Delve into the world of In-Memory OLTP, isolation levels, and their guarantees. Understand the challenges posed by bad dependencies and how they affect database performance. Examine the various isolation levels and their impact on concurrent transactions. Gain insights into the concurrency model specifically designed for in-memory tables. Learn about the unique storage mechanisms for in-memory data and how updating transactions are handled in this environment. Discover the implications of duplicate rows and how they are managed in In-Memory OLTP. Whether you're a database administrator, developer, or SQL Server enthusiast, this session will equip you with valuable knowledge to optimize your database systems for concurrent operations.

Intro
Slides
Background
Agenda
InMemory OLTP
Isolation Level
Guarantees
Bad dependencies
Isolation levels
Concurrency model
Inmemory tables
Storing data for inmemory tables
Updating transactions
Duplicate rows