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.
Sorry, there are no downloads available for this session.
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.
The video is not available to view online.