I missed the SQL 2000 limitation. Also, too many times we as DBAs need to solve these performance problems and that changing the client app is not an option.

...

Great article and I agree with almost all of of the point made and the solutions offered. I would suggest using a nonclustered index with a where clause to...