Posted by HC on 02/02/07 18:53

On Feb 2, 3:32 am, "Andrea Montanari" <andrea.sql...@virgilio.it>
wrote:
> hi HC,
>
> HC wrote:
> > ....
> > Considering that the same computer, against the same data, with the
> > same program, takes about 14 times (or more) longer to run, then it
> > has to be either that SQL Express 2005 is slow OR that my program is
> > interacting with it in an incorrect manner.
>
> http://msdn2.microsoft.com/en-us/library/ms190775.aspx...
> "...
> Important:
> To ensure optimal performance of an upgraded database, run
> sp_updatestats (update statistics) against the upgraded database on the SQL
> Server 2005 server.
>
> ..."
> did you?
>
> even better,http://msdn2.microsoft.com/en-us/library/ms187348.aspx
> UPDATE STATISTICS object WITH FULLSCAN;
> --
> Andrea Montanari (Microsoft MVP - SQL Server)http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> --------- remove DMO to reply

Thank you for your reply. I ran this against the two DB's I use and
then re-ran the report but it didn't make any real difference (about
10 seconds on a 4 minute 30 second job. Someone replied to the VB
thread and suggested re-building the DB from scratch in 2005 and
importing the data which is what I'm going to try next.

Thanks again for your reply.

--HC

[Back to original message]