Hi,
I am looking for a document/white paper that gives me a perforamance
comparison between SQL Server 2005 Vs SQL Server 2000. We are looking to
migrate existing code(without any changes) from SQL 2K to SQL 2K5 and client
is looking for performance improvement figures. I am sure many of you might
have faced similar scenario.

Regards,

[quoted text, click to view]

You can compare some of the results for 2000 and 2005 at www.tpc.org.
Without conducting your own tests it's very hard to make any reliable
assumptions about the performance impact of a straight upgrade. Your
results will be heavily dependent on the type of processing, on your
hardware and on whether processes are IO-bound or processor-bound. The
biggest gains are to be made if you can redesign your system to take
advantage of improved features like partitioning, indexing or
Integration Services.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--