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.
