How to resolve performance issues on SQL 2000
Posted on 2011-09-26
I wrote a stored procedure to retrieve lots of data say from around few millions database records. I have use all the optimizations such as use of temp table, indexes etc... though the peformance improved but still we want performance to increase. What are my options?
a) Without Migrating to SQL 2005, can we use the features of 2005 for the speed, i understand this is a silly question but something like writing that proc in 2005 calling from 2000 etc etc...
b) Any other options i have? Without doing any big change.
Any suggestion will be highly appreciated.