Oh, one other side note. (this has not happend yet, since there were almost no indexes) But I like to only have about 3 Non-Cluster indexes on tables, unless they are for reporting.

Since our reporting tables only get written to once per day, the overhead of having more indexes is offset by the bonus of not doing table scans... then again the most indexes I have added to any of these tables, so far, has been 4.