22-25 April 2026
Book Now

Optimistic Concurrency Internals

2009

TL; DR

Learn all about Optimistic Concurrency and how it works under the hood in this one hour session.

Session Details

Interested in Optimistic concurrency but not really sure how it works? Then this session is for you.  Optimistic concurrency was introduced in SQL 2005 but it is rarely spoken about or well understood.  However, you can buck that trend by coming along to this session where you will learn about how you can be Optimistic DBA. Now there's an oxymoron if ever there was one....

Session will cover the following

  • Architecture of Optimistic Concurrency
  • Limitations and restrictions
  • Optimistic Isolation Levels
  • Row Versioning and the Version Store
  • Impacts in TempDB
  • Taking out the trash - Garbage collection
  • Monitoring Row Versioning

3 things you'll get out of this session

Speakers

James Rowland-Jones

microsoft.com/en-us/sql-server/sql-server-2019

James Rowland-Jones's previous sessions

Agnostic, Hybrid Big Data Integration using PDW and PolyBase
PolyBase is one of the most exciting, innovative features in PDW; enabling transparent data integration with Hadoop's distributed file system (HDFS) and Windows Azure Storage Blobs (WASB). See it in action.
 
Demonstrating PDW integration with Hadoop & Polybase
Polybase is one of the most exciting, innovative features in PDW; enabling transparent data integration with Hadoop's distributed file system (HDFS) and soon Windows Azure Storage Blobs (WASB). See it in action.
 
The Art of War-Fast Track Data Warehouse & Fragmentation
When loading a Fast Track Data Warehouse it is important to ensure that your data is optimally laid out for Sequential I/O. Fragmentation is therefore the enemy. Know your enemy. Learn what it is, how it occurs and prevent it from happening to you!