Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

At our organisation we are migrating to SQL Server from visual foxpro dbf and hence had no maintenance plans and have no DBA. We have gone through our backup plans and Index maintenance is only index rebuild as and when required.

I wanna propose a new plan for index maintenance but wanna be sure if am wrong about it.its like Daily Index reorganizing and index rebuild as and when required (weekly or as late as monthly).

As I understand reorganize can be done online and will reduce accumulation of fragments.

Does clustered index duplicate the table or it just reorganizes the table?

Also would like to know if there are any other aspects of sql server maintenance that i need to look-up.

Sorry for so many question, just curious about many things.

share|improve this question
You can watch this 1 hour video by Paul Randal -- Index Fragmentation: Internals, Analysis, and Solutions! There is no better explanation than this. – DenisT Jul 3 '14 at 15:24

Take a look at

He has a great maintenanceplan which is free to use. I am using it for every project.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.