No announcements
Found 2680489 threads
-
2 VotesHow to lock row for update and prevent Race Conditions ?
I have used WITH (UPDLOCK, ROWLOCK) and it works on row level but for both*update* and *select.* Is there a way to make it works only on*update* without blocking ...Answered | 5 Replies | 4129 Views | Created by Ahmed Mohamed Naguib - Tuesday, September 6, 2016 5:14 PM | Last reply by Muhammad Asad (Partner) - Saturday, November 12, 2016 1:08 PM
-
5 Votes
How to lock row for UPDATE and prevent Race Conditions without blocking SELECT ?
You must indicate what you want thread 2 to do in this situation where it reads the same row that is currently being updated by another thread (or is it multiple ...Answered | 6 Replies | 2396 Views | Created by Ahmed Mohamed Naguib - Wednesday, September 7, 2016 2:45 PM | Last reply by scott_morris-ga - Wednesday, September 7, 2016 8:35 PM -
1 Votes
Unstoppable race condition in windows.forms
In other words, thread A can only close things if it acquires the semaphore (or critical section, meaning an object using Lock() in .Net).Answered | 3 Replies | 4522 Views | Created by MrManMan - Wednesday, March 23, 2011 9:31 PM | Last reply by eryang - Monday, April 11, 2011 3:05 AM -
0 Votes
Race Condition: Best way to solve
Try using 'lock'...Answered | 3 Replies | 3931 Views | Created by the.Programmer1 - Sunday, May 31, 2009 5:42 PM | Last reply by BRAHIM kamel - Monday, June 1, 2009 6:49 AM -
0 Votes
potential race condition in a delegate
Hi, Yes, there is a possible race condition here; if (ItemEnabledChanged !Answered | 3 Replies | 3040 Views | Created by PaulH79 - Wednesday, September 9, 2009 9:36 PM | Last reply by Yort - Thursday, September 10, 2009 9:22 PM -
5 Votes
Lock a row after SELECT and release after UPDATE
That's because when SQL Server locks a row, it doesn't lock that row in every index.Answered | 10 Replies | 3858 Views | Created by Naarasimha - Friday, May 24, 2013 10:12 PM | Last reply by Tom Cooper - Thursday, May 30, 2013 3:24 AM -
1 Votes
ConnectableObservable<TSource,TResult> - Bug / Race Condition
I think there is a race condition in Rx's implementation of IConnectableObservable<TSource,TResult>.Answered | 2 Replies | 4664 Views | Created by James Miles - Thursday, June 9, 2011 1:04 AM | Last reply by fixedpoint - Friday, June 10, 2011 6:00 PM -
0 Votes
Race and Point, Update seeing the position
How can I update this situation?Answered | 15 Replies | 1705 Views | Created by DIEGOCTN - Thursday, January 3, 2013 1:16 PM | Last reply by Naomi N - Thursday, January 3, 2013 5:10 PM -
0 Votes
Locking Updated Rows
Connection A cannot update nor delete a row R which is modified but not yet committed by another connection B.Answered | 5 Replies | 1218 Views | Created by Bin Ga3fer - Wednesday, May 21, 2014 6:38 AM | Last reply by Bin Ga3fer - Wednesday, May 28, 2014 6:09 AM -
1 Votes
Problem updating race standings
the competitions table based on the race result.Answered | 3 Replies | 9307 Views | Created by killerkay - Saturday, January 14, 2012 11:27 AM | Last reply by Robert Johnson - Thursday, January 19, 2012 12:27 PM -
0 Votes
Preventing Locks on checkout
yes, your correct, we have DLL's checked in to source control that are updated/rebuilt on compilation.Answered | 4 Replies | 7556 Views | Created by mickdel - Thursday, October 16, 2008 8:59 AM | Last reply by b.cooke - Thursday, August 26, 2010 12:49 AM -
0 Votes
How to lock row in the SQL Procedure
Locks ( ID, UserName, Timestamp ) where ID is the primary key of your row to lock and the UserName is e.g.Answered | 16 Replies | 2279 Views | Created by Abhinandan Abz - Monday, December 3, 2018 11:12 AM | Last reply by Tom Phillips - Wednesday, December 5, 2018 1:30 PM -
0 Votes
Update statement lock
How have you written the UPDATE block?Answered | 2 Replies | 954 Views | Created by Curendra - Sunday, December 2, 2018 9:21 AM | Last reply by Visakh16 - Sunday, December 2, 2018 12:10 PM -
0 Votes
Locking particular row for processing
Deadlock prevention: http://www.sqlusa.com/bestpractices/deadlock/ Consider Optimistic Concurrency instead of row ...Answered | 2 Replies | 1882 Views | Created by Nishit Badani - Monday, July 1, 2013 5:35 PM | Last reply by Kalman Toth - Wednesday, July 3, 2013 11:37 AM -
0 Votes
Locking rows in SQL Server database to prevent data loss/corruption during edits
Update locks would prevent readers as well as writers UPDLOCK only prevents writers.Answered | 11 Replies | 3197 Views | Created by clbassett03 - Friday, October 10, 2014 4:42 PM | Last reply by Uri Dimant - Sunday, October 12, 2014 12:53 PM -
0 Votes
U (Update) Locks
How/why does SQL Server decide to issue an Update lock as opposed to an 'S' lock?Answered | 3 Replies | 4657 Views | Created by Randy Minder - Tuesday, May 11, 2010 4:44 PM | Last reply by Mohammad-Sufian - Tuesday, May 11, 2010 7:06 PM -
0 Votes
How to do sql server row level lock
http://stackoverflow.com/questions/4596972/how-to-exclusively-lock-a-row-that-prevent-crud-operationAnswered | 11 Replies | 2035 Views | Created by Mou_kolkata - Thursday, October 27, 2016 9:57 AM | Last reply by Albert_ Zhang - Thursday, November 3, 2016 9:02 AM -
1 Votes
[WP8.1]Race condition causing uncatchable crash when changing AppBarButton Icon
Hi, using any Task.Delay workarounds for crashing race conditions is never good solution - the app might be slower or faster one day and the error happens again.Answered | 3 Replies | 649 Views | Created by Martin Suchan - Friday, July 24, 2015 1:42 PM | Last reply by Fred Bao - Monday, July 27, 2015 1:32 PM -
2 Votes
UPDATE lock on table
That is how sql works.Answered | 15 Replies | 5242 Views | Created by simonxy - Friday, September 27, 2013 1:33 PM | Last reply by simonxy - Thursday, October 3, 2013 8:44 AM -
3 Votes
Does updating a column result in a table lock?
After you update a few thousand rows, the update query will probably trigger lock escalation to a table lock.Answered | 10 Replies | 1462 Views | Created by steveosmith - Thursday, May 16, 2013 9:11 PM | Last reply by Rechousa - Thursday, May 16, 2013 10:54 PM - Items 1 to 20 of 2680489 Next ›
No announcements
