quote:
You should manually update the statistics. Auto update statistics does not run immediately after you dump data into the database.Yes, SQL 2000 may jump in and update the stats but it certainly doesn't look like it has in your case, and why leave it to chance?
Checking BOL the auto update runs "periodically" based on the number of the rows in the table. SQL 2000 may consider your new 50000 records as not enough to update.
Run Update Stats after every data dump and save yourself a lot of worry.
Patrick