Platinum Sponsor

From Locks to No Locks – Concurrency in SQL Server

In this session, we’ll explore the good and bad about locking and blocking – essential mechanisms inside SQL Server that every database developer and administrator needs to understand thoroughly. Locking and blocking affects performance and data integrity, and we’ll see how we can influence that functionality under pessimistic concurrency control as well as how snapshot isolation changes the game.

This session will focus on reading data (while being blocked). We’ll consider table & index design and query hints, why we should rarely if ever use NOLOCK, and what alternatives we have. Be prepared for a demo-& code-intensive session – no “GUI-action.”

Presented by Andreas Wolter at SQLBits XII
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Andreas_Wolter.jpg

    Andreas Wolter is both a Microsoft Certified Master (MCM) on SQL Server 2008 and a Microsoft Certified Solutions Master Data Platform (MCSM) SQL Server 2012 and has also been awarded with the MVP for SQL Server. He is the founder of Sarpedon Quality Lab, a Germany-based company that specializes in Development and Optimization of SQL Server Database- and Datawarehouse-architectures with focus on performance and scalability as well as a special passion for security. With over a decade of experience with SQL Server he can be met at various international conferences and delivering training for the SQL Server Master-Class seminar-series held in Europe. You can follow him at Twitter at @AndreasWolter.

    http://www.insidesql.org/blogs/andreaswolter/ http://www.insidesql.org/blogs/andreaswolter/?tempskin=_rss2
  • Video
    The video is not available to view online.
  • Session Files Explorer
    The network name cannot be found.