Posted by steve on 11/08/07 20:03

On Nov 7, 7:00 am, Yash <yas...@gmail.com> wrote:
> Hi,
>
> We are in the process of tuning the performance of our stored procs in
> SQL 2000 and are looking for a tool that would help us in comparing
> the result sets of an old SP and a modified SP.

Wouldn't it be nice if such a tool was not even necessary!

Basic Anatomy of Sql Server, part I
What is a stored procedure?
http://beyondsql.blogspot.com/2007/11/basic-anatomy-of-sql-server-part-i.html

Basic Anatomy of Sql Server, part II
The unit test as part of the database.
http://beyondsql.blogspot.com/2007/11/basic-anatomy-of-sql-server-part-ii.html

Basic Anatomy of Sql Server, part III
What does deferred name resolution really mean?
http://beyondsql.blogspot.com/2007/11/basic-anatomy-of-sql-server-part-iii.html

www.beyondsql.blogspot.com

• Next in forum: MS SQL 2000 formatting numeric value to money
• Prev in forum: Re: CASE count wierd join needed maybe? just one more field needed!
• Thread view: Re: Tool for comparing result of 2 stored procs

[Reply to this message]