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.
Many apperceive the cast Tag Heuer, which has replica watches uk some arising collectible examples. The added abnormal and colorful, the added absorption they get. This includes the Monaco model, although these models accept rolex replica already acquired abundant cachet to be on the top ancillary in agreement of amount if they accept accustomed able affliction and storage. Other brands with abeyant for beginning collectors are Ulysee-Nardin, Universal Geneve and Longines if in excellent condition, all of replica rolex which are featured in Haines book Vintage Wristwatches.