I think I'm going to have to do some reading.

The preference is to use the first rather than the longest, or first/last in the alphabet.

But honestly, I'm new at this...

I have never used Rollup,

I need to check that out.

That is what I was thinking. I was trying to figure a Case method but couldn't come up with one.

Actually the DB isn't mine (DB9 using a Linked Server)...

Yep, oddly enough that was the first thing I asked them when we got to this part.

And the answer is....

'Oh yeah, we had this problem before with a new hire....

Hi Gail, hope everything is well. How are things abroad?

Ah well, since you asked. I personally would not use this as an index for the very reason you...

Hmm, that was so easy I'm embarrassed.

But then you had to go and bring reality into it.

How about KP1 and KP2? hehe

What would you suggest?

Thanks,

I may have to try that.

The on-going saga of upgrading to SQL2005, sigh...

Now the DBA is updating statistics nights. On the table (tbl_PR) that has a bulk import the Stored Procedure executes and update...

Grant,

There are quite a few pay types. However I've already started looking to reduce the Where clause.

I was also looking at a temp table for the OpenQuery...

Thank...

Oh I read your blog before replying. Nice job by the way.

Since we just upgraded I'm not sure now often (or if) the admin is running Update Statistics. ...

Yes Gail...

Updating the stats worked and the query ran in just a few seconds. Sigh...

So my next question is should I / can I modify the Stored Procedure...

Thank you yet again.

This upgrade is going considerably smoother with your help,

I hope I'm able to return the favor...

I have no doubt the SQL may be questionable since I'm still fairly new.

So in addition to that you're saying that SQL 2005 may run somewhat slower on some queries....

Thank you for your help but, of course, I have a new questions.

I believe the admin ran the Update Stats, yesterday and everything seemed to work. I have another...

Bingo,

I spoke to the admin. He just ran update statistics (and some other thing???) and yeah!!! It worked.

Thank you,

Now we'll have to schedule the other db's and run the...