Thanks for taking the time to respond Fahim.

Well, except for the rows where the referenced_minor_id = 0, then it is obviously talking about a column, and referencing_minor_id is returning a...

Ron - thanks for the great question. Heck, thanks for all the great questions that you do!

Hugo - thanks for the great clarifications / explanations that you do so frequently...

(Bob Brown) (9/5/2012)

---

KWymore (9/5/2012)

---

Nice question. I only got this one right because there was another sparse column question recently that I had to do research on.

I would...

Gianluca Sartori (9/4/2012)

---

WayneS (9/4/2012)

---

Gianluca,

I think I've run across the same limitation, and I've been revamping this script from being process-based to being lock-based. I wanted to add the intra-query parallel...

Mark-101232 (9/4/2012)

---

See if this helps

select

MainLock.Process.value('@id', 'varchar(100)') AS LockID,

OwnerList.Owner.value('@id', 'varchar(200)') AS ProcessId,

...

Mark-101232 (9/4/2012)

---

See if this helps

select

MainLock.Process.value('@id', 'varchar(100)') AS LockID,

OwnerList.Owner.value('@id', 'varchar(200)') AS ProcessId,

...

Gianluca,

I think I've run across the same limitation, and I've been revamping this script from being process-based to being lock-based. I wanted to add the intra-query parallel processing items, and...

Hey Threadizens - I'm having an issue shredding some xml (a deadlock graph) - one query gets the info, but another doesn't. If you feel like taking on this challenge,...

Thanks Tom,

I have to agree with your assessment. I would have expected the name, data type and null-ability to all be >95%.

I actually felt that this question was so easy,...

I'm curious as to why a SQL 2000 reference was used (although the 2012 reference states the same, this one is specifically for 2000).

There are a bunch of limitations and...

If you have the deadlock graph in XML format, use my script (http://blog.waynesheffield.com/wayne/code-library/shred-deadlock-graph/[/url]) to shred it and see what all is going on. If this doesn't help, post the XML...

Hey Jack - why are you dissing all of your Threadizen buddies?:-D:-D:-D

http://wiseman-wiseguy.blogspot.com/2012/08/im-speaking-at-sqlsaturday-156providence.html

4 Threadizens doing 8 presentations, and you're not seeing any of them?:w00t:

And what's up with only seeing presentations where...

Brandie Tarvin (8/22/2012)

---

GilaMonster (8/22/2012)

---

jcrawf02 (8/22/2012)

---

GilaMonster (8/22/2012)

---

BrainDonor (8/22/2012)

---

I have to say Gail that it was a fascinating thread up to a...

dwain.c (8/21/2012)

---

It has been a rare experience for me to post a question to this forum, but I will now. How about a poll?

Yesterday I was called upon to...

How many Threadizens are planning on going to SQL Saturday 156 in Providence, RI on 9/15?

(I already count 5 presenters...I think we may need a SSC / Threadizen table...