• 1) Be careful adding a bunch of columns to an index just to make it covering. There is maintenance cost and disk storage cost to this.

    2) An index on the date won't be helpful if a months worth of data is more than ~8-10% of the table, unless said index is covering.

    3) If your predominant access of this table is by date range, consider making the clustered index the date field used.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service