Faster Queries Without NOLOCK!

SQL Server offers two methods for applications to provide multi-user concurrency and provide data consistency: Pessimistic and Optimistic Concurrency Control. In this seminar we’ll discuss what consistency might mean to your applications, and describe the details of how each concurrency model works internally. We’ll examine the costs and trade-offs between the two models. Finally, we’ll examine the metadata and tools available for analyzing and troubleshooting problems.
  • Why is concurrency management a crucial part of database tuning?
  • How does SQL Server implement pessimistic concurrency with locking?
  • How do we get true optimistic concurrency?

Pre-requisites
Basic knowledge of TSQL Querying
Laptop Required: Optional

  • Software: Delegates can follow along with some of the demos if they have a laptop with SQL Server 16 or later installed, with the latest Management Studio,.
  • Subscriptions: They can connect to an Azure SQL Server or SQL DB if they do not have a local one, but it is not required.

Speakers

Wednesday 27 February 2019