Introduction to Statistics

Statistics are used by SQL Server to try to make better decisions about query plans. Typically we want auto create and auto update statistics options on, and in this video we'll talk briefly about why and show you where to find the settings.

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.

rupesh sharma on 12/9/2009

excellent

Kevin MacKay on 12/9/2009

Great start...Keep them coming...

iceman on 12/9/2009

I love these short videos. Simple and to the point. I can always do more research.

Feodor Georgiev on 12/9/2009

Great intro! Looking forward to the next videos.

srinivas on 12/9/2009

this video gives basic information about statistics...

Stephen on 12/9/2009

Nice intro to Statistics. Can't wait to see the series.

Rick Fonner on 12/9/2009

This was a GREAT start to an area that is currently very gray to me right now.

SpeedRoush on 12/9/2009

Excellent, Statistics are such a mystery since it's so difficult to find info about the who, what, when, where regarding them. thansk

Marcelo Marim on 12/9/2009

Great intro.

Puja Potdar on 12/9/2009

I liked it and was very simple and easy to understand. I am looking for more information as in what scenarios you should create statistics manually and when it should be automated esp in a data warehouse where data is humangous Also it would be nice to see use of statistics in execution plans etc.. Thanks

Mark E. Siltala on 12/9/2009

Looking forward to more!

msuess on 12/9/2009

Brief, informative, clear, great.

John O'Sullivan on 12/9/2009

a good introduction

Kumar Duraisamy on 12/9/2009

I love this video lession

Leonard Peoples on 12/9/2009

Can't wait to hear more about stats.

Steve Harris on 12/9/2009

great introduction. maybe explain why having the async option defaulted to false is also valid.

Sam Schafer on 12/9/2009

Andy did a great job - very good presentation. Although I know what statistics are and what they do, I still learned something. Nicely done!

Munna Bhai on 12/9/2009

Really a great intro....Excellent video.

Mark Kenyon on 12/10/2009

good stuff

Christian Bahnsen on 12/10/2009

Thanks. Looks like this will be an entirely new facet of SQL Server for me to digest/assimilate, but that's the value of these videos.

Amy Darroh on 12/10/2009

A good intro. Thanks!

Pedro Gonçalves on 12/11/2009

Nice intro to SQL Server stats. Thanks!

Luis Sayegh on 12/12/2009

Good video!

Vijay on 12/13/2009

I heared two voice so i could not able to hear the tutorial properly

Piyush on 12/16/2009

Cool, short and to the point waiting for the next one in the series.

m on 12/16/2009

not working

BAB0DDB76E on 12/29/2009

Very usefull info. Thanks!

0E2501D79F on 12/29/2009

Interesting!

Warren on 3/20/2010

Just wanted to say although I am taking a SQL DBA class I have found these short 3-5 minute videos super helpful and hope to see them continue

Olu on 5/13/2010

Thanks - it gave me a good understanding of why statistics are neccessary

Ravi Raj on 6/29/2010

good one