The group by doesn't sort at all. A table doesn't have any defined order on it. By definition, it's an unordered set of records

When you say max(periodDate) ... group by...

It would, if level 07 wasn't in your desired output 3 times. The max period date is...

Check that the compatability mode of the database you're running this in is set to 90

Use SQL Profiler

I can't speak from personal experience w.r.t the DTA, as I've never used it outside a class room. I prefer to tune by hand.

What I have noticed with it is...

Have you had a look at the queries that are running against that DB? It could be that they are performing sub-optimally, doing more IOs than necessary, resulting in high...

Not permitted. Not in 2000 or 2005 transactional replication

What problems are you having with the 90GB db?

If there's nothing else running on the server, set the max memory to around 2.75GB and min to 2 GB

If its performing OK, then leave the index as it was. A massive, great covering index (especially in SQL 2000) may...

The guid should be in single quotes, but other than that, I can't see anything wrong. I also can't see a '575' where the error could be near.

Can you post...

Can you please post the schema of the temp table, and the table you're updating from, as well as some sample data for both and the desired output.

Thanks

You may even get a different number of rows inserted into the table in the second one. Union eliminates duplicate rows.

Please don't cross post. It fragments replies and wastes people's time

Continue here

In the sample data you gave it is one of the latest...

I don't have a handy copy of express to play with, but you should be able to configure the server's min and max memory settings from management studio express.

In the...