SQL Server 2000 performance
sql 2000 does have some performance tools built into them.  Run these on your queries to see if they give you any help.


Query Analyzer
Profiler
Index Wizard
Performance Monitor