Usually, SQL takes care of the UPDATE Statistics automatically.
However, there may be situations where this does not occur, e.g. when the number of UPDATEd / INSERTed / DELETEd rows does not reach or exceed the specified threshold (default 20%, changable from SQL2008R2 SP1 using trace flag 2371) for auto-updates (especially on large tables)
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”