Index is not rebuild unless you tell SQL server to do it.
I have found quite useful to create a maintenance plan.รน
Right-Click on Maintenance Plans and create a new plan:
Undem Maintenance Plan Tasks (left) drug to the workspace the "Rebuild Index Task"
and then doubleclick to get the properties:
Customize your task. You can select DBs to reindex.
With the Calendar icon schedule how often you wish it to run.
Note: plans will then appear in the Jobs Area:
This comment has been removed by a blog administrator.
ReplyDeleteThis comment has been removed by a blog administrator.
ReplyDeleteThis comment has been removed by a blog administrator.
ReplyDelete