SQL Server maintenance: Indexes Tuning

Microsoft SQL Server has the capability to help you decide which index(es) to add after monitoring your "typical" database access activities for long enough time. To do this, Start Profiler in Microsoft SQL Server, then New a Trace and Run. After you have collected enough "Typical" database activities, you can stop and save the trace, then use the Tools -> Index Tuning Wizard to let the wizard analyze your trace and made suggestions on you. If the suggestions make senses to you, you can just accept it and the wizard will automatically add/modify the indexes for you.