THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » indexes » statistics   (RSS)
  • October Update to Rules-Driven Maintenance

    Happy Fall! It’s a beautiful October here in Minneapolis / Saint Paul. In preparation for my home town SQL Saturday this weekend, as well as the PASS Summit, I offer an update to the Rules-Driven Maintenance code I originally published back in August 2012. It’s hard to believe this thing is now more than two years old – it’s been an incredible ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on October 9, 2013
  • Rebuilding Indexes vs. Updating Statistics

    One of the questions I was asked recently while speaking at user groups, was regarding the order that jobs like rebuilding indexes or updating statistics should be performed as part of the database maintenance activities. Then I started writing this post about this topic on the weekend but was interrupted several times, including one of them to ...
    Posted to Benjamin Nevarez (Weblog) by Ben Nevarez on October 6, 2009
  • Did You Know? Statistics vs Indexes

      What is the difference between statistics and indexes? Do auto created statistics indicate that you should build an index? I will be posting answers to some of the interesting questions I get from my students and my readers (these are not two disjoint sets, of course) on the new SQLCommunity site. Check out this the answer to this ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on February 4, 2008
Privacy Statement