laurie-789651 (6/25/2014)

---

If you're using the sys tables (i.e. views) as source of the table names, use the columns view to identify the required column name & store this along with...

Jeff Moden (6/13/2014)

---

Since you brought it up,...

Lynn Pettis (6/13/2014)

---

jfogel (6/13/2014)

---

Ah, I see. Once I remarked out two of the select statements in Lynn's query before the cross apply I see just the desired result. Much more...

Ah, I see. Once I remarked out two of the select statements in Lynn's query before the cross apply I see just the desired result. Much more graceful method than...

Here are the create/insert statements I used in my example:

drop table Queue

drop table Tasks

drop table QueueTaskLink

CREATE TABLE Queue(

QueueId INT NOT NULL PRIMARY KEY IDENTITY(1,1),

MaximumQueueLength...

Your insert statements, etc are a complete mess! That didn't help at all, but I hope what is posted below will. I do not claim this is the best, or...

Put it in a stored procedure and wrap the groups in a try/catch. Log each group and send an email upon failure.

Tell them it is a report. If they want a work of fiction they should call Stephen King.

I think Aspergers is on its way out as a diagnosis. Regardless, We've all worked with people who are difficult and the difficult ones who stick around (read not fired)...

Spot on. Also, unemployment for a DBA is only one stupid mistake away.

glyn-1145829 (6/12/2014)

---

Many of the DBA's I...

Simon,

It isn't that I do not agree with you, but not involving the DBA is somewhat common. At best those companies have a database designer on staff, but that is...

simon.crick (6/12/2014)

---

Tavis Reddick (6/12/2014)

---

[p]I am having some difficulty understanding the categorizations of roles used here.

[/p][p]My understanding of a database administration role is close to Wikipedia's, where a DBA looks after...

The...

It makes a big difference when developers can rely on help from the DBA. I've been in many situations where I've suggested to a dev that their statements, while they...

No. I did some testing with it and found the performance increase to be very nice. However, in order to get the tables involved to comply with requirements they basically...