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

• Next in forum: Re: replacing join operation in XML
• Prev in forum: Re: Doubt about SQL Server
• Thread view: Re: SQL Slow from MSDE 2000 to SQL Express

[Reply to this message]