Blog feed not updating

Of course, the worst case scenario would be if you first rebuild your indexes, which also updates the index statistics by scanning the entire table, and later you run UPDATE STATISTICS using the default values, which again updates the index statistics but this time only with a default and smaller sample.

Not only you are updating your index statistics twice but you are overwriting the better of the two choices.

Since the first job only updates index statistics and the second one only updates column statistics, it does not matter which one you execute first.

Some other more complicated scenarios include when you have jobs which rebuild your indexes based on their fragmentation level.

One of the questions I was asked recently while speaking at the Los Angeles SQL Server Professionals Group and the Orange County SQL Server User Group (*) was regarding the order in which jobs like rebuilding indexes or updating statistics should be executed as part of the database maintenance activities.

In general you should consider the following important points, focusing in the fact that there are two kinds of statistics: index and column statistics.

Benjamin has also been a speaker at many SQL Server conferences and events around the world including the PASS Summit, SQL Server Connections and SQLBits.

His blog can be found at he can also be reached on twitter at @Benjamin Nevarez.


My ticker and news feed are not updating, despite me logging out, clearing my cache, trying different browsers, et cetera.

Found a script that does fix the issue most of the time. Copy this to .vbs, run it on the client machine having issues.

Then restart the sms service and re-run your cycle (software update, etc).

Run again the query to verify that a new statistics object for the Product ID column has been created.

Notice the value of the auto_created column which tells if the statistics were automatically created by the query processor.4) Reorganizing an index, for example using the ALTER INDEX …


  1. Pingback:

  2. eric   •  

    Life in cities or remote parts of the country leaves very little room for personal life.

  3. eric   •  

    A study by Gülseren et al suggested that food additives may be involved in the etiology of RAS.

  4. eric   •  

    I Galatasaray tränades Friedel av Graeme Souness som han senare skulle stöta på igen.

  5. eric   •  

    This will ensure that your model account is properly linked to your Payoneer account.

  6. eric   •  

    Hypergamy (colloquially referred to as "marrying up") is a term used in social science for the act or practice of a person marrying another of higher caste or social status than themselves.

  7. eric   •  

    He raved about the Performance Inspired Nutrition creatine and BCAAs that he takes after spending the […] Lea Michele spent Halloween on the couch watching scary movies with a takeaway pizza. “I keep my home completely vegan, which I think is one of the most important things,” The Mayor actress told Us Weekly at a recent ABC event.

  8. eric   •  

    If things get awkward, they can always rewind the encounter and try again.

  9. eric   •  

    With simplicity in mind, the intuitive firewall makes it easy for you to adjust settings to the best level of protection.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>