dakshiw (6/26/2011)
Yes, WITH FULLSCANI decided to go for once a month job at this stage. Feel that's sufficient, Might keep weekly as an option.
Thanks Michael.
Not nearly enough.
The 1 issue that's going to bit you in the arse is when you have a [small]datetime column that is insterted with the value of today or getdate().
The stats will soon become stale and cause you to have bad plans >> the server will expect 0-1 rows to be returned instead of 1000s.
Here's the full story :
I'm working on something to solve this issue but it's not completed yet. Ping back if you don't hear from me in the next couple of days.