Posted by Andrea Montanari on 02/02/07 09:32

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

• Next in forum: Re: How to remove rows where only part of the row is duplicated
• Prev in forum: Re: How to remove rows where only part of the row is duplicated
• Thread view: Re: SQL Slow from MSDE 2000 to SQL Express

[Reply to this message]