• Index maintenance can be a little trickier on a reasonable sized OLTP database if you are working with the Standard Edition of SQL Server, as the online option is of course not avaialable.

    This is why it becomes advantageous to use a customised index maintenance stored procedure say, as you can tweak the optimisation process accordingly. i.e. determine whether to rebuild/reorganize dependant on fragmentation levels and to limit optmisations to only those specific indexes that require it etc.

    Take a look at Michelle Ufford's (SQLFool) stored procedure for index optimisation[/url]. One of the best index optmisation scripts I have seen.

    Cheers,