RBarryYoung (3/6/2009)

---

I think that some things should be pointed out here, lest someone reading these posts gets the wrong idea...

First, there is no such thing as an "MSDN MVP" it's...

GSquared (3/6/2009)

---

jcrawf02 (3/6/2009)

---

To you, Chris, or to someone who knows that they're doing....

Putts (3/6/2009)

---

Grant, I did create that missing index but, as you assumed, it did not help the performance.

I would agree with your sentiment that there must be something awry with...

rudy komacsar (3/6/2009)

---

Hey Grant - no problem - was just trying to get some suggestions out there based on the limited information - personally I index-defrag before index rebuild and...

Putts (3/5/2009)

---

Okay.

Was able to get acceptable times on the original query I was working with but now I'm working on a different one and am running into the same problem.

Following...

groffg (3/6/2009)

---

2 weeks is the "standard" for new hires, but employees who have been w/ the company longer will likely have much more. Ditto for "special" employees who have in-demand...

Yeah, you'll have a few joins, it's still not that many and the indexing should be very simple. The one thing I'd suggest, instead of trying to pivot the data...

You've just hit the hardest part of the migration out of 2000, retiring DTS. I'd suggest a mixed approach. Run the Upgrade Adviser and let it scan your DTS packages....

It's the leading edge that makes the most difference, yes. I'd drop one of the two indexes.

Out of the box, without installing anything else, you can use perfmon to gather performance metrics on the server and set up a server-side trace to capture the performance metrics...

I'd say if most queries are coming through on the inv_no & month_no columns, then those are probably the best candidates for the clustered index. But, with 176 columns, you're...

Definately use INFORMATION_SCHEMA system views is the way to go for stuff like this.

Does the syntax of the view have WITH SCHEMABINDING in it? If so, simply remove that.

What is it you're trying to do?

Just speaking for myself, I'm posting for three reasons. First, I've been helped in the past, so I try to help others. Second, this is a fantastic learning opportunity. When...

Let me state up front that I am absolutely, adamantly, passionately against unionizing our industry in any way...

If the gun were held to my head and I was forced to...