Using sp_autostats

SP_Autostats is a really convenient way to see what statistics exist for a table and whether they are active or not. We'll show you how to view all the stats, change their status, and even use it to change a single statistic on a table.

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.

luther smith on 1/4/2010

Good info

E72B0A9423 on 1/4/2010

I had not heard of the procedure mentioned. Very helpful to know of it.

Narasmha Rao on 1/4/2010

Very nice and informative..Thanq for sharing it

Don Weigend on 1/5/2010

It is interesting that auto stats can be turned on or off at the stats level, I am not sure what good it would be to manage stats at such a fine level. Perhaps a future video could explain that. As always, thank you for the tip!

skaykov on 1/5/2010

VEry Interesting and useful.

skaykov on 1/5/2010

VEry Interesting and useful.

skaykov on 1/5/2010

VEry Interesting and useful.

skaykov on 1/5/2010

VEry Interesting and useful.

on 1/5/2010

Not sure what autostats is for, so doesn't help much to know how to use it. Yes, I can read BOL yada yada but then i was hoping for something complete in this video. Explain the value first before explaining how - thanks anyway

valluru raghu on 1/5/2010

Excellent

Andre du Plessis on 1/7/2010

I agree with the previous yada yada comment. I am unsure how it affects the system.

Mark on 1/8/2010

Did not go into what sp_autostats are or are used for

A Alagu Ganesh on 5/4/2010

good

nilesh bilimoria on 11/16/2010

what's autostats anyways?