Maintain index on SQL Server table
You could set up a job to rebuild or reorganize them weekly/daily.

I recommend checking out http://sqlfool.com/2011/06/index-defrag-script-v4-1/

This index rebuilder is highly customizable.