Viewing 15 posts - 1 through 15 (of 37 total)
Thanks Eric,
I will think about adding retry logic to my deadlock victim process.
And thanks everyone for your feedback. I think I understand this a bit better now.
March 27, 2018 at 9:20 am
Northern Soul wrote:
"I hope I've explained this clearly but have a look at books online for more detail."
Yes, perfectly clear, but see my follow up question below...
March 26, 2018 at 12:46 pm
INSTEAD OF DELETE seems to work for my purposes.
March 16, 2018 at 9:09 am
ON DELETE SET NULL only works if you set it on one of them. Otherwise you get this error:
"Introducing FOREIGN KEY constraint 'FK_Consequence_RiskMatrixAxis_LikelihoodAfterSafeguard' on table 'Consequence' may cause cycles...
March 13, 2018 at 4:45 pm
All right, well guess I gotta bight the bullet. Thanks sgmunson.
March 9, 2018 at 10:43 am
sgmunson - Thursday, March 8, 2018 9:10 AM
Excellent! That link has the answer I was looking for....
March 8, 2018 at 2:55 pm
Thanks everyone,
Turns out this was causing the return of -1:
SET NOCOUNT ON
If I set NOCOUNT to OFF, it returns the number of rows.
March 7, 2018 at 7:42 am
March 6, 2018 at 12:36 pm
March 6, 2018 at 10:22 am
Hello everyone,
Thanks for all the replies. Sorry for the late response.
On Friday, I was preparing a response to each of your posts until I got to Sergiy's request...
March 5, 2018 at 3:10 pm
Oh, and I forgot to mention: sys.dm_exec_sessions confirms that it is our application session that's doing the blocking (where the file is uploaded).
March 1, 2018 at 4:23 pm
Thanks for the replies Gila,
I know I'm playing with fire with the page/row locks and the lock_escalation, but I made a backup of my database before doing anything and...
March 1, 2018 at 4:01 pm
Ok, I think you guys are right about getting the exact error from the API instead of plowing ahead with the assumption that it's a locking issue. I say this...
March 1, 2018 at 1:50 pm
March 1, 2018 at 9:00 am
Thanks everyone for your feedback. I will try the things you suggested.
In the meantime, I used sp_who2 active to figure out that the database session for saving the...
February 28, 2018 at 2:19 pm
Viewing 15 posts - 1 through 15 (of 37 total)