Simple • Straightforward

So easy a Caveman
Programmer can do it.

›› Let's Get Started

Statistics

This Ain't No College Class

Statistics are very important to databases running quickly. They let SQL know how best to run queries based on the data that has been inserted and the indexes you have setup. I would recommend most people setting up their databases to Auto Update Statistics. If you forgot to set this during the database creation, just run the following command:

ALTER DATABASE YourDBName SET AUTO_UPDATE_STATISTICS ON

If you think it affects performance too much (maybe you have 10,000 users on the system at once), then it might be a good idea to setup a job to run hourly. You can find that setting here:

Maintenance Plan Wizard

And if you are feeling like this needs to be run manually, you can execute the following statement:

EXEC SP_UpdateStats





Comments

Name:
Title:   
Commenting Currently Disabled


Kaydi
8/3/2011 5:06:14 PM



Always the best cntoent from these prodigious writers.