Later this afternoon, I’m presenting at the Columbus, Ohio, SQL Server User Group meeting. The topic: SQL Server Locking and Blocking Made Simple.

Heeeeeeerre’s the abstract

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.

I’ll discuss:

• The different types of locks that SQL Server uses
• How and when SQL Server uses lock escalation
• When to use different transaction isolation levels
• The different granularity hints that are available

I hope you’ll join us for this event. For connection and dial-in information, visit the Columbus SQL Server User Group web site.

See you there. We’ll I’m actually presenting remotely, but as a figure of speech, I’ll see you there.

Joe