I sometimes do a mass update in Query Analyzer.
ie. Update t1 Set f1 = 'Y' WHERE f1 = 'Yes'
If this is a very large dataset and can take 3 or 4 minutes, my web application that reads this same table can't view a single record while this update is going on.
It will timeout if I just want to query a single record in this table based on the primary key. Is there some way to run that update and allow others to view records while the update is occuring?
ie. Update t1 Set f1 = 'Y' WHERE f1 = 'Yes'
If this is a very large dataset and can take 3 or 4 minutes, my web application that reads this same table can't view a single record while this update is going on.
It will timeout if I just want to query a single record in this table based on the primary key. Is there some way to run that update and allow others to view records while the update is occuring?