Gail,

Your summary wraps the entire conversation into an easily understood statement. Thanks.

Willem

Erland,

Thank you for your reply. I guess I was thinking that the DENY would outrank even the Sysadmin status, having heard the saying 'DENY always has precedence.....' for so long....

Nalini,

The POC project ended up being scrapped so I never got to the point of trying out my '3-to-1' Always-On situation - the vanilla '1-to-3' situation, the one everyone...

Gail, here's the index definition - pretty straightforward.

Willem

Gail, I've attached the two actual execution plans. This is the first time I've attached something and I think I did it right. Let me know if I didn't!

...

Gail, there is only one index on the table and it's a unique clustered index on two columns - one column is an identity column and the other is a...

Melliot,

The table that seems to be the center of my deadlock is 350 KB, definitely bigger than a page. Your response brings up a point I've never had to think...

SQLRNNR, thanks for the link. However, the deadlock I'm dealing with definitely has two users - two different stored procedures are accessing the same table. I just can't find the...

Gail, you're right. I went back to take a look and I 'exagerrated' a little when I said two years!:-)

Here's the entire deadlock graph -

<?xml version="1.0" encoding="utf-8" ?>

-...

I apologize for the delay - last week was a bear! The answer is that I've not made any progress with it, mostly because of last week. However, my question...

Gail, because I've only read about it and never actually run into the situation like this before, I've never really had a need to fully understand the issues surrounding changing...

Gail, thanks for the reply. I had forgotten about the pseudo-simple mode and I'll bet that is what is going on - I can't think of any other way that...

And the prize goes to the man in the DBA hat!! That was it - one of the groups of which this user is a member is included in the...

Andrew,

Thanks for the probing question. The databases were not created using an application login but rather by a user running a script. The script is one from Microsoft that creates...

Thank you both for responding to my question. I ended up applying the earliest CU that contained the fix for my users' problem rather than trying to contact Microsoft and...