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...

I just talk about the information on a form, like a drivers license. It all gets stored somewhere and I'm the guy that manages the stuff that does the storing.

Dropping all indexes may help with the inserts, but then again it might not. It really depends on if any of them are necessary for lookup operatoins during the inserts....

No, there's no way to change it. It's funny that it's called a timeout because it actually isn't. It's a set number of times that the optimizer will attempt to...

Try adding p.Date_Last_Requested as an INCLUDE column on the Person.CorvId_FirstName_LastName_Email index. That would eliminate the key lookup operation you're getting to retrieve that one column. That will help, a lot....

Yeah, I checked it. At my previous employer we were automating builds, both complete and incremental, for the last couple of years. Make sure it's checked on all projects involved.