Viewing 15 posts - 31 through 45 (of 70 total)
This is the update statement within the sproc which is getting stuck and creating deadlock (when run parallely in various sessions)
February 15, 2011 at 4:34 am
First enabled ALTER DATABASE DatabaseName SET ALLOW_SNAPSHOT_ISOLATION ON. Then inside sproc mentioned SET TRANSACTION ISOLATION LEVEL SNAPSHOT. While running it shows error saying "Transaction failed because this DDL statement is...
February 15, 2011 at 3:43 am
Snapshot isolation didn't worked. It seems it does not work in a sproc where update statement is defined.
February 15, 2011 at 2:45 am
1. Database is Case Sensitive.
2. Function definition is attached.
3. We have to equate the condition that way.
4. I'll check that out.
5. It's A.COBDate= B.COBDate (I'll rectify that)
February 14, 2011 at 11:28 pm
Gail, I read your article again and again. That's interesting but still I'm not able to get solution. Can you check for example the attached execution plan and Statistics and...
February 14, 2011 at 10:45 pm
Gail, Isn't Conflict detection present in Snapshot isolation ? Apart from that, is there any way by which we can neglect deadlocks ? Using some locking hints or something ?...
February 14, 2011 at 4:38 am
That is something which can be achieved using jobs. However I have to work withing codings to avoid deadlocks. I am stuck and not getting any solution.
February 14, 2011 at 2:38 am
srikant, No issues of different order usage of tables, since we are using same procedure in different sessions (only with different parameteres)
February 14, 2011 at 1:43 am
I'm planning to use SET TRANSACTION ISOLATION LEVEL SNAPSHOT before update. Will it help me avoid deadlocks ?
February 14, 2011 at 1:32 am
I checked all almost all of the things. Everything looks fine to me. However there is one update which affects around one thousand rows (on an average) on a table....
February 13, 2011 at 11:17 pm
Hello Gail, I read both the links and they are quite useful. However my main problem is little different. We are using one procedure parallely multiple times (around 30 times...
February 13, 2011 at 9:22 pm
Hello Grant, I'm really not able to figure it out, though I tried a lot. We are still facing the issue.
February 2, 2011 at 10:30 am
Thats true if you have only one Field1 value. However if you need resultset for lots of Field1 values, then TOP is not going to work.
February 2, 2011 at 8:33 am
Viewing 15 posts - 31 through 45 (of 70 total)