Statistics RRS feed

  • Question

  • As per my knowledge, sql server statistics get updated when a number of rows(which are required to met the threshold level to update statistics) get inserted into a table. But recently I check the statistics of some tables on production environment, in which thousands of records get inserted daily, are having outdated statistics.

    I wonder why sql server did not trigger update statistics mechanism on those tables even after thousands of rows are getting inserted.

    I also read in some blogs that sql server update rows by sample the rows . How this sampling take place and is updating statistics on the basis of samples is an effective way to get up to date statistics.

    Please HELP.....

    Saturday, December 12, 2015 9:22 AM


All replies