July 2014 Vegas UG Meeting

Categories: News, Professional, SSSOLV
Tags: , ,
Comments: 3 Comments
Published on: July 9, 2014

Coming up this week is the Vegas UG meeting.  Keith Tate has been gracious enough to accept our speaker invitation and will be presenting.

The meeting will be held 10 July 2014 at 6:30 Pacific.  Location and time details can be found on our meetup page.

BIO

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 Curious Case of Isolation Levels

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.

LiveMeeting Info

Attendee URLhttps://www.livemeeting.com/cc/UserGroups/join?id=BSG34W&role=attend

Meeting ID: BSG34W

3 Comments - Leave a comment

Leave a comment

Your email address will not be published. Required fields are marked *










Calendar
July 2014
M T W T F S S
« May   Aug »
 123456
78910111213
14151617181920
21222324252627
28293031  
Content
SQLHelp

SQLHelp


Welcome , today is Wednesday, March 29, 2017