i know this says sql 2005.. but the platform I am running on is sql 2000.
i have a database with 1.17 million records.
I need to make a change to 131,000 of these records.
The best way determined to handle this change is through a cursor.
To update 1,000 records it takes 5-6 minutes. I think this is unacceptable because to update 131,000 records it will take roughly 11 hours.
Being new to table and performance handling, can someone direct me in the right direction to decrease the amount of time it takes to update 1,000 records?