I spoke about Locking and Concurrency in SQL Server.
The session focused on the different lock types available with SQL Server and how they affect database concurrency.
We looked at the available Concurrency Models supported by SQL Server, Isolation Levels, Lock Modes, Conversion Locks, Lock Duration, Key Locks, Lock Starvation, Lock Escalation, Table Hints and how we can resolve Blocking issues and improve Concurrency which in terms improves our applications response time.
The presentation includes many examples in T-SQL that you can try out for your self to see with your own eyes which helps remembering better.
To download the presentation:
http://www.sqlserverutilities.com/download/Locking-Concurency-ppt.zip
-Yaniv
====================================================
