>Yes - as long as you are doing something with the table to make the server need to access it, it should remain cached (at least somewhat which will make the next access much better). IIRC I had my scheduled app running hourly after normal business hours.
Do you also know if this can be related to a recent backup? The backups are done at 01h00 and last for about an hour. But, that situation occurs two hours and 20 minutes later. We did not get any hit on that table however during that timeframe. So, I am wondering if a SQL Server backup can reset the cache. Do you know if that could have been a factor?