title: SQL statistics on large databases
body: <p>What is a good way to handle statistics on SQL 2008 for very large databases? Multiple tables with 100m+ rows in each.</p>
  
  <p>Should auto update statistics be on? Will auto update statistics async help at all? should a job be setup to manually update statistics on some kind of schedule?</p>
  
  <p>Usually data is added to the table but older data isn't changed very often.</p>
  
  <p>Update: About 100k rows inserted each hour. Mostly reporting is done on the data. Updates can happen on 1-2 columns on ~500k rows per day.</p>