212 reputation
18
bio website
location
age
visits member for 2 years, 4 months
seen Aug 8 at 12:24

Jul
2
awarded  Curious
Apr
22
comment How do I deal with query getting slower when a select parameter is not specified inline?
@DavidCrowell: No, the view is not indexed and AccountId is uniqueidentifier.
Apr
21
awarded  Yearling
Apr
21
comment How do I deal with query getting slower when a select parameter is not specified inline?
I cannot insert MAGIC into code generated by Linq-to-SQL.
Apr
21
asked How do I deal with query getting slower when a select parameter is not specified inline?
Feb
28
accepted What causes lost updates being observed in my SQL Azure database?
Jan
24
comment What causes lost updates being observed in my SQL Azure database?
@MartinSmith: I've added an answer explaining what it really was.
Jan
24
comment What causes lost updates being observed in my SQL Azure database?
@EdwardDortland: The problem was resolved and I added an answer.
Jan
24
answered What causes lost updates being observed in my SQL Azure database?
Jan
17
comment What causes lost updates being observed in my SQL Azure database?
@MartinSmith: The deal is I always see that the UPDATE decrements the value which wouldn't be the case if the order was different.
Jan
16
comment What causes lost updates being observed in my SQL Azure database?
@EdwardDortland: The time of those duplicates is the same with "up to second" precision. The table definitions are simplified but the "SELECT from UPDATE" thing is as actual as it could be - it's a single UPDATE statement and MSDN claims that lost updates are impossible under any isolation level in SQL Server.
Jan
16
comment What causes lost updates being observed in my SQL Azure database?
@MartinSmith: Yes, that's what I'm relying on. If this doesn't work how do I get the right "SELECT from UPDATE" effect?
Jan
16
comment What causes lost updates being observed in my SQL Azure database?
@EdwardDortland: I added the table definitions. The AvailableMoney thing is "current state" and the two others are there for historical purposes so that I can look back and find what the balance was at some specific time.
Jan
16
revised What causes lost updates being observed in my SQL Azure database?
added 712 characters in body
Jan
16
asked What causes lost updates being observed in my SQL Azure database?
Jan
15
awarded  Informed
Dec
12
comment Can I limit the time a table lock is being held server side?
@ThomasStringer: That's the problem. If it's client side there's a chance that the server is unaware and continues having the lock held.
Dec
12
comment Can I limit the time a table lock is being held server side?
@ThomasStringer: If it's a server side thing how would I set it in SQL?
Dec
12
comment Can I limit the time a table lock is being held server side?
@Kin: Okay, I don't mind the lock disappearing and the transaction waiting for it being rolled back with error. I guess that would be ACID enough. I can sacrifice one transaction but I want the lock disappear after some time. Can I have that?
Dec
12
comment Can I limit the time a table lock is being held server side?
@ThomasStringer: Well, what if there's a connection timeout and there's a protocol error and the transaction continues in the server but the client gets an error? That's what I want to protect from.