It's about halfway through the year, when record sets are getting bigger and bigger (for those who are doing YTD transactional storage). So, I can see August being just the...

Eat it!

WayneS (8/31/2010)

---

Hey gang...

I saw a post yesterday (I think) where someone had figured out how to post the greater-than/less-than signs in code snippets where they would show up that way....

Next time this is running, run SP_WHO2 a few times to see if you can catch the deadlocked SPID (or watch Activity Monitor & refresh often).

If you can get the...

george sibbald (8/31/2010)

---

not anymore, you've got an n+1 cluster, same...

Lemme ask my last question again:

From the second line "2010-08-30 06:45:05.76 spid18s deadlock victim=process3c27c18", what is this process?

EDIT: I see that it's a DELETE statement of some sort, but from...

I've got an Active/Active/Active/Passive cluster. @=)

Silly question. Are you log shipping to the same server / instance as you're getting the logs from?

What side of the log shipping is the deadlock happening on? The sender...

Maybe, Alvin. I wonder, though, how many of us are DBA by title, but DB-Everything by practice?

Or DB-Everything by practice with just a different title and the admin is just...

Alvin Ramard (8/31/2010)

---

...

Just kidding folks. We ALL need to stay! We can all contribute, and we can...

That's right.

doctor

GilaMonster (8/31/2010)

---

Brandie Tarvin (8/27/2010)

---

ACK! We've been invaded! There's one of those...

battle

Wayne, It's not my code. It's someone else's. Yes, changing the code to that was one of our thoughts, but we're not sure if that will fix the issue. That's...