Title: Understanding Isolation in SQL Server 2000 and 2005
Abstract: SQL Server 2000 offers four levels of isolation — a full implementation of the ANSI/ISO standards for isolation. But, did you know the standards mostly cover data access and behavior, not implementation? Because of this, different products can behave differently and have different “phenomena” occur in each level. In this session, we cover the four standard isolation levels and how they work by default in ALL releases of SQL Server as well as the new features offered in SQL Server 2005. SQL Server 2005 offers two new flavors of isolation whose enforcement is very different than the traditional levels… new to this release are non-blocking, non-locking read transactions where readers don’t block writers and writers don’t block readers. See how BOTH of these new settings are turned on as well as when/why you should use them. If you want to make your data more available and minimize livelocks and deadlocks, this is the place to be!
Australian Speaker: Ron Talmage
New Zealand Speaker: Ron Talmage