Updating Statistics - Part 3

We continue looking at techniques for manually updating statistics by walking through the options provided in maintenance plans. Easy to implement, only one minor gotcha to know about!

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

Sandip on 12/21/2009

Helpful.

SpeedRoush on 12/25/2009

i'm so lacking in my understanding of statistics you're filling my glass quickly. Been using SQL since 6.5 and never got into this aspect. thks for the info.

Prakash on 12/31/2009

Index Rebuild always update the statistics with full scan(100%). People should take care when updating statistics after index rebuild, since this end up in overwriting the statistis from full scan to a sample one.

Jim Phillips on 12/31/2009

You missed an important point in this video. If you rebuild your indexes the index is taken offline while it is being rebuilt and this will effect performance greatly if the system is being used during a mainenance window. Not all maintenance windows are completly hands off. A reorg does not drop and recreate the index and affects performance less for those 7X24 applications. A update stats should be done after an reorg during the window.

Mark Sopczak on 1/1/2010

Great video, I did not know that. Thanks!

Sam Schafer on 1/4/2010

This series on statistics has been very informative and well presented. Definitely worth the time to review.

Yul Wasserman on 1/7/2010

Andy, what will happen to the [index-based] statistics if,say, the index gets dropped? Thanks, --yul yul@ugo.com

Murali on 1/7/2010

realy good

Andy Warren on 1/8/2010

Yul, the associated statistic is dropped at the same time.

A Alagu Ganesh on 5/4/2010

good

venkatesan on 5/10/2010

very nice video