Reply to Re: SQL Slow from MSDE 2000 to SQL Express

Your name:

Reply:


Posted by Erland Sommarskog on 02/02/07 23:21

HC (hboothe@gte.net) writes:
> 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.

It could help, but I would count on it.

A better approach is to analyse the query plans in SQL 2000 and SQL 2005
to understand where the differences are. You can do this from
Mgmt Studio Express which you can run against both SQL 2000 and SQL 2005.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация