It's very easy way to update statistics in sqlserver, There are several ways.
1.By creating Maintenance plan from maintenance wizard.
2.By setting a property on data base level, it is automatically updating.
First Way:
1.Choose Management
2.Then Choose Maintenance palns
3.Then Right click on 'Maintenance palns'
4.Choose New paln option
5.Then it shows controls for Update statistics
6.Drag update statistics control to the control area
7.Set data base coneection
8.Set which data base you want to update statistics
9.Click on OK
10.Choose .... button for Scheduling Job
11.Define when it is going to be run
12.It's better to run by sundays :)
13.Then save that maintenance paln with desired name
14.Check the job is scheduled or not in Job Activity monitor
15.There we can find our maintenance paln
16.Then the fun starts on sundays, If we set that job on sundays
hahahahaha.....
Second Way:
1.Choose data base
2.Right click on the desired data base.
3.Choose properties
4.Then choose options
5.Set Auto create statistics property is True
6.Set Auto update statistics property is True
7.Close the window
Haaha this is very easy.......
No comments:
Post a Comment