We have a C# system throwing up an oddity we can't get to the bottom of with SQL (SQL2k5). The situation is that we have two seperate processes running simultaneously looking at the same table, both running inside their own transaction in two different serviced COM+ components on two different clusters. Both are talking to Order and Ord...
What could possibly go wrong with the following transaction if executed by concurrent users in the default isolation level of READ COMMITTED? BEGIN TRANSACTION SELECT * FROM t WHERE pid = 10 and r between 40 and 60 -- ... this returns tid = 1, 3, 5 -- ... process returned data ... DELETE FROM t WHERE tid in (1, 3, 5) INSERT INTO t (tid...
Hi all! I will describe my problem for an easier explanation: I have a table and my soft is accessing it (update, insert) using transaction. The problem is that I want to enable DIRT READ in this table. But I cant use with (nolock) in my sql statements because I cant change the soft source. So I was thinking in enable dirty read in th...
Just a thought, but would using an IFRAME over a DIV essentially make that element isolated from the window in a way that slow scripts running in the IFRAME wouldn't affect the other frames/window? ...
Is there a way to just put an attribute to a method so that the whole code in the method is executed in a transaction scope? I've seen this done in sharp architecture but I'm using Linq to sql not nhibernate. Thanks! This what I would like to do: [Transaction] public void InsertCustomer(Customer customer) { //insert customer } So th...
We are developing a website quite similar with ebay.com and in order to upgrade/maintain it without much effort we decided to split/isolate different parts of the website like ebay does too (e.g the item page/application will be served from cgi.domain.com , signin application from signin.domain.com, shopping cart application from offer.d...
I have a deal and transaction table, where the deal table has an aggregated column, 'TotalSales', which is simply a count of transactions per deal. With the following command, is there ever a chance the transaction row count and total sales count would not be in sync (not including deleting rows)? Does the default isolation level work f...
I understand a little about Oracle blocking - how updates block other updates till the transaction completes, how writers don't block readers etc. I understand the concept of pessimistic and optimisic locking, and the typical banking textbook examples about losing lost updates etc. I also understand the JDBC transaction isolation l...
EDIT seems my original post below might have been a bit long. Simply said, can I spawn some AppDomains and ensure that they cannot communicate with one another in any way? There is a competitive robotic soccer simulation league called RoboCup 3D. One of the fundamental rules is that all communication between agents be conducted thro...