Friday, October 11, 2013

SQL Server 2005 - How to Rebuild Indexes periodically

Rebuilding indexes speeds up searches into a SQL Database. Your applications will benefit!
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:








3 comments:

  1. This comment has been removed by a blog administrator.

    ReplyDelete
  2. This comment has been removed by a blog administrator.

    ReplyDelete
  3. This comment has been removed by a blog administrator.

    ReplyDelete

Microsoft Teams doesn't open

 Hello! My Microsoft Teams stop working! Searching .... I found this solution that worked: Delete the content of: C:\Users\<profile>\A...