Just a quick question. Probably would hve answered earlier in this forum, but I couldnt found an answer which relate to me.
In a SQL server (SQL2005) which runs financial systems of an orgnization, how often it is recommend to run the Update Statistics job?
Microsoft recommend not to run th job often as it clears query cache. Im just wondering whether it should be an overnight job or a job which runs once in a monthly/ weekly.
Appreciate your suggestions/ recommendations in advance.