Leslie,

To tabularly summarize the results

Mtehod     LogicalRead  Est Cost CPU Elapsed Time

No-Index   6797             5.440   651 28002

Clustered   632              0.545   230 21500

Non-Clust   33689       206.00     461 13880

So except for the elapsed time the Clustered Index...

Vladan,

Thanks for the response.

As far as missing information I agree with what you said, except that I do have the line number as part of the primary key for OrderItem...

I can tell you this:

Where I work we have tools that will query the database and open lots of new connections very fast under the right conditions.  Some of those...

My one suggestion as far as CPU goes, dual would probably be better.

My reasoning is that since the machine will be hosting other apps, you will probably want to be...

Your code is doing exactly what you tell it to do.

Logically you are saying

If HAS ACTIVE CHECKING then check some other things, otherwise we are done. Or another way of saying...

I agree with jb_lbm two extra points.

One little item brought up at the end, is the when SQL Server re-starts, tempdb will be the size set in model, as SQL...

The SQL looks good except every Suday is one digit behind.  I am not sure what the solution is to that little glitch.

I also tried running it for december and...

Actually I think you do not need to uninstall 9i.

I believe the headache comes from not selecting the correct connection in DTS.

First make sure that the server where the DTS...

I would definately look at the query/stored procedure.

At a minimum run the query through index tuning wizard allowing and see if it suggests some better indexes.  Also check out the indexed views...

As you may have found out: DateDiff is useless for your problem as it only compares a part of the the date/time.  Fortunately I was able to figure this out:

Use...

I would say that you would need to query the contents of the INFORMATION_SCHEMA views and compare the data in them.  You will need to use names, not internal IDs,...

I can tell you two things:

1. You can probably do more than 100 records at a time.  When I did this I found 10-14000 worked relatively quickly on deletes and...