SQLDay 2015 | DBA | From Locks to Dead-locks. Concurrency in SQL Server - Andreas Wolter
In this session we take a look at essential mechanisms inside SQL Server, which influence administrators as well as developers and should be known thoroughly.
Why does SQL Server have to lock objects, which effects does this have (performance and data integrity) and how we can influence these things.
· can indexes prevent locking?
· why is NOLOCK not a good idea when dealing with critical data?
· when and what happens at Lock-Escalation?
· what does table-design have to do with blocking?
· why everyone should know error number 1205 – how deadlocks can occur and what can prevent them?
· how is „optimistic concurrency“ implemented in SQL Server?
As usual: lots of (code) demos