Just to give an update:

I got the query to run in under 15 seconds by simple removing a table that wasn't needed. For those of you that have seen my...

Just does to show that you can't use Crystal's database expert to browse and join files and expect it to work well. Always do the work on the sql server...

OK, so I completed my migration over the weekend and in doing so had to recopy the database from the 2000 server to the 2005 server. I ran the update...

Actually the vendor has me run the DBCC UPDATEUSAGE as part of the upgrade process. So that's been done already.

Just an update....

I ran UPDATE STATISTICS <Table Name> WITH FULLSCAN on every single table in the database and it did indeed improve performance. It went from a 2 hour query...

I ran your script Gila and got 6960 objects. I also updated statistics on all tables related to that crystal report and reran the query. I don't think that solved...

Thanks ss-457805. Running that script, I see 543 objects popup the oldest date is 12/14/2009 that is the date that the database was upgraded to 2005. So it seems to...

Just asking because there are 906 tables in this database. 🙂 I'm going to try to speed things up by querying all tables and running a script to update them.

Is there a way to tell if statistics was already updated?

If it's very important to update statistics, then I would be very surprised if it wasn't already taken care of...

Yes, this is a very recent upgrade. Now that I understand what the statistics are (sort of 😉 ), I'll run those on the tables in question first to see...

The tables are part of a database from an accounting package that we purchased some time ago. The definition changes from the 2000 to the 2005 are the result of...

OK, I've (hopefully) attached everything I need to. I included table and view definitions, row counts, and execution plans.

sql server 2000.zip contains information related to the older database I mentioned...

Thanks for the link GilaMonster. I'll get all that information together and post it this afternoon. I'll let the query run for the two hours so I can get the...

What statistics and how do I check them?

I'll post the execution plans in table format.

george sibbald-364359 (11/12/2009)

---

personally I would stick the full backup just after the integrity check, then do the rest of the operations.

by the way you probably do not need to reindex...