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

It is. It was lifted, whole hog, just, badly.

Phil Factor mentioned on a tweet yesterday that another MVP in...

rudy komacsar (3/5/2009)

---

Take a look and see if there is any database maintenance/optimization. If not, then that is a great first step. As Jeff said, there is no reason things...

Sorry, I was away. Did Gift Peddie's post help because I was going to suggest the code page or possibly the collation next.