GilaMonster (5/2/2011)

---

Hey Grant, due to the Order By that SQL Pass uses on the submitted sessions page, you and I are listed consecutively for all sessions. 🙂

Totally irrelevant and useless,...

That's weird. It popped up on my RSS feed. I should only see new posts. I didn't even bother to check.

SQLRNNR (5/2/2011)

---

Grant Fritchey (5/2/2011)

---

GilaMonster (5/2/2011)

---

Grant Fritchey (5/2/2011)

---

Steve Jones - SSC Editor (5/2/2011)

---

Brandie Tarvin (5/2/2011)

---

GAH!

I have a lot of love for Brian Knight and Pragmatic Works (his company), but I'm about...

A guide for people to write their own queries? Completely unqualified people? No. I wouldn't suggest that. Instead set up a reporting system with templates and models that they can...

Without the execution plan the only thing that really leaps out at my eye is the use of DISTINCT in the derived tables. That can frequently be a crutch for...

To me a design document would include an entity relationship diagram, probably a logical, not a physical model, naming standards, coding standards, descriptions of acceptable data loss for the business,...

GilaMonster (5/2/2011)

---

Grant Fritchey (5/2/2011)

---

Steve Jones - SSC Editor (5/2/2011)

---

Brandie Tarvin (5/2/2011)

---

GAH!

I have a lot of love for Brian Knight and Pragmatic Works (his company), but I'm about to throw stones...

Steve Jones - SSC Editor (5/2/2011)

---

Brandie Tarvin (5/2/2011)

---

GAH!

I have a lot of love for Brian Knight and Pragmatic Works (his company), but I'm about to throw stones at SSIS Guy...

Without more information it's hard to know. I'd suggest going after the wait states to see what's causing stuff to slow down. But you should also check that the system...

Why do you have multiple party types? What's the point?

But, to get all party information back, probably the best way is a UNION ALL query where you join each individual...

Yeah, the best performance tuning questions come up on here, all the time. But you can also look at my blog, Paul White's blog[/url], Gail Shaw's blog, and pick up...

Steve Jones - SSC Editor (5/1/2011)

---

So I've gotten more than a few complaints about posts like this from Syed Jahanzaib Bin hassan.

http://www.sqlservercentral.com/Forums/Topic1101142-146-1.aspx#bm1101269

I can certainly appreciate he/she is annoying, and not...

To post the plans you can save it as a .sqlplan file and then upload it.

If you're seeing differences, then these are different plans. Without seeing the plans, it's hard...

I haven't heard anything publicly that would indicate it. If I had heard anything privately I couldn't tell you about it (but I haven't).

That's the right flag. I just did a full test to validate, incrementals are created by having this off. Do you have your target set appropriately? If the target is...