-
Joe Webb
4.64
Description:
A good working knowledge of how SQL Server makes use of locking and transaction isolation levels can go a long way toward improving an application’s performance. In this session, we will explore SQL Server’s locking methodology and discover techniques for enhancing query response times.
Links: Website
Comments on this Talk
lrubakhin,
15 Sep 08:47 PM
Great presentation! Code examples were very useful.
dschutz,
16 Sep 02:12 AM
Joe did a great job talking about locking and blocking. He explained what they really are and how they affect our SQL processes. He also offered tips on how to alleviate deadlocks and blocking.
John Jakubowski,
16 Sep 02:39 PM
Joe delivered an engaging presentation which provided a solid understanding of how SQL Server uses locking/blocking and transaction isolation levels. The talk provided a concise explanation of the methodology involved as well as useful tips and techniques for addressing and mitigating the impact.
This presentation clarified a large amount of SQL Server's locking and blocking mechanisms and gave me the background I needed to solve my day to day problems. Joe made great use of both slides and code samples to illustrate the different isolation levels, their side effects, and the concepts of locking, blocking, and deadlocks. I feel like I have a solid understanding of these concepts that will serve me well going forward.