Wed, Aug 27 2014 12:00 Eastern Daylight Time
The Curious Case of Isolation Levels – sponsored by Dell Software
Have you ever seen or used “WITH (NOLOCK)” in T-SQL? Do you know what it does and its side effects? Is SQL Server optimistic or pessimistic when it comes to locking? Can it be both? In this session we will cover these questions and discuss how and why SQL Server takes locks and how that affects other users. We will go over alternatives for using NOLOCK and discuss when it is appropriate to use. In addition, we will discuss what are the ACID properties and how to monitor locks and blocks.
Keith Tate is a Microsoft Certified Master in SQL Server 2008 and a Senior Database Administrator with over 14 years of experience as a data professional. During Keith's professional career he has been a developer, DBA and data architect. Keith is also active in the SQL Server community and is currently the chapter leader of the Albuquerque SQL Server User Group.
The DBA Virtual Chapter presentations are recorded. On the Meeting Archive page, you will find .WMV files that can be viewed on-line.
We can always use people to give a talk at one of our bi-monthly events. If you are interested in giving a presentation, please send your title, a brief abstract and a brief bio to Sharon Dooley, firstname.lastname@example.org.
September 10 Noon Mountain Patrick Akhamie Transaction Log file management (SQL Server 2008r2 – 2012)
September 24 Noon Eastern Sreeni Julakanti SQL Server Statistics
The DBA Virtual Chapter holds two webinars on the second Wednesday of every month at noon, Mountain time and on the fourth Wednesday of every month at noon, Eastern time. These 1 - 1¼ hour presentations include slides, demos and a time for questions and answers. The meetings are recorded and archived.
We thank our sponsor