Hi,

I've a very strange problem , my store procedure read 1 record at time from a table , mark it by update and the finish.
The store was called several hundread times by an application ... the effect consinst in a decrease of performance by store ...

The most problematic thing was the decrease can remove by launching "update statistics " on the relative table;
At begin I can run the "update statistics" one time at day ... now to permit at application to work I've scheduled a job one time at minute ....

Why my Databases continuos to degrade to the final collapse?