Viewing 15 posts - 7,606 through 7,620 (of 9,720 total)
Oddly enough, I was thinking "Weird Al" when I posted "Eat it!" but Marathon Man works. @=)
Today's word: Filibuster
September 1, 2010 at 4:11 am
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...
September 1, 2010 at 4:09 am
WayneS (8/31/2010)
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....
August 31, 2010 at 12:25 pm
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...
August 31, 2010 at 12:13 pm
george sibbald (8/31/2010)
Brandie Tarvin (8/31/2010)
WayneS (8/31/2010)
So, based on this, can you now explain what an Active/Active/Passive cluster is?I've got an Active/Active/Active/Passive cluster. @=)
not anymore, you've got an n+1 cluster, same...
August 31, 2010 at 12:09 pm
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...
August 31, 2010 at 11:25 am
WayneS (8/31/2010)
So, based on this, can you now explain what an Active/Active/Passive cluster is?
I've got an Active/Active/Active/Passive cluster. @=)
August 31, 2010 at 11:05 am
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...
August 31, 2010 at 11:03 am
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...
August 31, 2010 at 8:40 am
Alvin Ramard (8/31/2010)
GilaMonster (8/31/2010)
Not a DBA, never been a DBA. Should I leave now?
...
Just kidding folks. We ALL need to stay! We can all contribute, and we can...
August 31, 2010 at 8:31 am
Chris Morris-439714 (8/31/2010)
Brandie Tarvin (8/31/2010)
doctorWho?
That's right.
August 31, 2010 at 8:22 am
GilaMonster (8/31/2010)
Brandie Tarvin (8/27/2010)
Alvin Ramard (8/27/2010)
Differential vs incremental, that was my mistake, but I don't care because I'm not a DBA. 😀
ACK! We've been invaded! There's one of those...
August 31, 2010 at 4:05 am
Viewing 15 posts - 7,606 through 7,620 (of 9,720 total)