Hi David,
Unfortunately, I don't have any links or books to recommend. For me it's always "trial and error". :)
You can always get help here on UT, though.
>
>Thanks a lot for your help. Your suggestion to use case statements worked really well.
>
>My project manager asked me to also try a series of nested if statements, thinking that the server would cache the selects and we would get better performance. We found that the performance of the two was comparable. The nested if statements resulted in a shorter, sharper burst of CPU usage, while the case statement used about a fourth less processor time, but for about a third longer.
>
>Do you know of any set of basic rules for optimizing stored procedure performance on Microsoft SQL 2000 aside from experiments and experience? We are starting to use a lot of stored procedures for our current project and I would like to write the most resource-efficient stored procedures that I can. Even knowing the ways in which SQL Server 2000 optimized queries would be useful.
>
>I am reading "SQL Server 2000 Stored Procedure & XML Programming, Second Edition" by Dejan Sunderic, which I like as a resource. If you could share recommendations for other print or web resources, I would appreciate it.
>
--sb--