Tatsu (7/25/2012)

---

I looked into it a little more and I don't think you're going to find it. It...

I did add myself on the install. The issue I think I am having has to do with cross domain. My local development PC is on a different...

General question here. Anyone got an idea on how to get alerted/notified/emailed on this. Our server actually went down and we didn't know the witness couldn't see the...

The types table has a PK on the ID column, so it can't have duplicates.

Fraggle

Jack,

Was afraid you were going to say it. Would you recommend a table hint of SERIALIZABLE or TABLOCK or something different?

Nathan

Not really sure what you are asking. Can you be a little more clear?

Have you reviewed the permissions of the job? How are you trying to do the...

Lynn,

Thanks. I can't wait to see your unique solution to this.

Thanks

Fraggle

Lynn,

That sounds interesting. Could you provide more details on the implementation on that.

Thanks,

Fraggle

I would have been ok with a 1 minute delay. In this case, we never got notified. Period. 30 minutes later we found out by chance as...

Geoff A (5/24/2012)

---

did you want this alert to fire on the principal?

what was the reason the failover occured?

how long did the failover take?

and the alert seems a bit off... you...

Ok,

First, it appears that you have 3 unique records

RecNum Patient_ID Patient_FirstName Emp_ID Emp_FirstName App_Datetime

1 1234 John 9876 Adam 5/12/2012 9:00 am

2 1234 John 8765 Steve 5/12/2012 10:00 am

3 1234...

General question. Is...

GilaMonster (5/1/2012)

---

Fraggle-805517 (5/1/2012)

---

Gila, I tend to agree with you on the Deadlock as not being the issue. However, when I killed the SPID that was deleting the backup history,...

GilaMonster (5/1/2012)

---

I doubt the deadlock is the cause. More likely, the deadlocks are another effect.

Deleting lots of rows can be a very expensive query. If it parallels and uses lots...

Sure, here is one of the chains:

...