Wrox Programmer Forums
|
BOOK: Professional SQL Server 2008 Internals and Troubleshooting
This is the forum to discuss the Wrox book Professional SQL Server 2008 Internals and Troubleshooting by Christian Bolton, Justin Langford, Brent Ozar, James Rowland-Jones, Steven Wort; ISBN: 978-0-470-48428-9
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server 2008 Internals and Troubleshooting section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 17th, 2011, 09:45 PM
Registered User
 
Join Date: Jan 2011
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Lost updates concurrency effect

The lost updates is well explained in list of concurrency effect but it was not explained which isolation level can prevent this concurrency problem later in the same chapter. Is read uncommitted the right isolation level. Kalen Delaney book on sql server 2008 internals simply mention that read uncommitted prevent this. Other books present the lost update as solved by the data repeated read isolation level. What is your opinions
? Thanks





Similar Threads
Thread Thread Starter Forum Replies Last Post
CONCURRENCY pallone SQL Server 2000 13 December 6th, 2006 12:01 PM
Concurrency problem sanjaymannnet ASP.NET 1.0 and 1.1 Professional 0 July 10th, 2006 05:42 AM
Concurrency Issue billy_bob_the_3rd Classic ASP Components 1 October 23rd, 2004 09:33 AM
Concurrency dextertoh Classic ASP Databases 2 May 17th, 2004 12:53 AM
Concurrency Violation performing Database updates LaFeverMF VB Databases Basics 1 February 15th, 2004 01:51 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.