Jeffrey Williams 3188 (12/31/2013)
How often are you updating statistics?
How often are you rebuilding your indexes?
Have you reviewed the 'slow' queries to see if they can be improved?
Just a few thoughts...
We update statistics every evening.
We rebuild indexes every evening if fragmentation > 30%.
The queries aren't slow except when they are.
Yes....... I'm from Oklahoma where the fork in the road is taken.
Thank you for your questions. Your response is sincerely appreciated.