4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

Locked Away in Splendid Isolation

SQL Server offers several Transaction Isolation Levels and a hole variety of different locking-related query hints.  Many database developers a vaguely aware that they are there, but don't really understand them or know when they should be used.  Others sprinkle the NOLOCK query hint liberally through their code, using it as the answer to any and every performance problem.  This session examines what isolation levels are available, how they correlate to locking hints, what their effects are and when to use them.
Presented by Andrew Whettam at SQLBits XII
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    Andrew_Whettam.jpg
    Andrew Whettam is a Consultant for Information Management Group and has previously led the Database and Business Intelligence teams for 3M and Capital One respectively.  He works with both transactional and analytical databases and has modelled, designed and developed database systems across a variety of industry sectors.  Recent IMGROUP projects have included roles as Data Modeller for a major financial institution and Data Architect for a large conglomerate.  Past experience includes a number of high profile government projects.  He has worked with all versions of SQL Server since SQL 7.0.
    http://www.imgroup.com/blog/Pages/Blog.aspx
  • Video
    The video is not available to view online.