There's a lot in there that needs addressing. The biggest issue is all the places where there are functions on the columns like this:

AC.dt>=(cast(CASE WHEN dbo.AGM_isdatenull(POR.PromiseDt) = 1 THEN POR.DueDate...

TomThomson (9/3/2015)

---

Alvin Ramard (9/3/2015)

---

Grant Fritchey (9/3/2015)

---

Another funny one today. Provided a DMV and a link to the documentation. I was asked "Is that real?"

Nope. Just faked out the entire MSDN...

Alvin Ramard (9/3/2015)

---

Ed Wagner (9/3/2015)

---

Grant Fritchey (9/3/2015)

---

Alvin Ramard (9/3/2015)

---

Jeff Moden (9/3/2015)

---

Alvin Ramard (9/3/2015)

---

Grant Fritchey (9/3/2015)

---

Another funny one today. Provided a DMV and a link to the documentation. I was asked...

sqlkohai (9/3/2015)

---

I wish I could, I'd get in hot water if I posted things because for the most part, I'm not supposed to be tinkering at all 🙂 I'll...

Alvin Ramard (9/3/2015)

---

Jeff Moden (9/3/2015)

---

Alvin Ramard (9/3/2015)

---

Grant Fritchey (9/3/2015)

---

Another funny one today. Provided a DMV and a link to the documentation. I was asked "Is that real?"

Nope. Just faked out...

Jeff Moden (9/3/2015)

---

Alvin Ramard (9/3/2015)

---

Grant Fritchey (9/3/2015)

---

Another funny one today. Provided a DMV and a link to the documentation. I was asked "Is that real?"

Nope. Just faked out the entire...

Brandie Tarvin (9/3/2015)

---

Grant Fritchey (9/3/2015)

---

Another funny one today. Provided a DMV and a link to the documentation. I was asked "Is that real?"

Nope. Just faked out the entire MSDN web...

Another funny one today. Provided a DMV and a link to the documentation. I was asked "Is that real?"

Nope. Just faked out the entire MSDN web site to pull a...

If it doesn't do what...

Yes. Click on the link. It's a dynamic management view (DMV) for tracking referenced objects from another object. It does at least part of what you need. The only issue...

Not really. Certain parts of the language seem like a pain until you see all the possibilities for their use.

Let's take schemas. Most people, most of the time, use dbo...

AAAAARRRRGGGHHHH!

The STUPID! It burns.

No, no links. Just needed to scream in agony for a moment. Go about your lives.

Nope. If you change them to be owned by you, you have to give different sets of permissions to all the users. They won't even necessarily see them. Further, good...

If what you're looking at says that SQL Server is consuming 24gb, that's what it's consuming, not 24 + 100. You're missing the point.

Also, while there is some OS memory...

ZZartin (9/3/2015)

---

I've never said I think foreign keys are bad, all I've said is that I don't understand why some people consider them a must have. If an application...