Gathering Stats with SIZE AUTO

Pros
Works for most cases.
Job is automatically created and scheduled when database is created.
Cons

• Not always clear when histograms will be used.
• Column usage can affect stats gathering, ie difference between Production load and Test load on the same datasets

See Hermant's article on Column Usage affecting histograms here, here, and here.