• Just grouping by functional area isn't necessarilly going to help with I/O. Do you have multiple disks and multiple controllers? If not, just adding another file and filegroup isn't likely to help performance much.

    It's collecting 10gb of data a day, which could add up quickly, but you're only keeping a day's worth, right? In order to avoid fragmentation, what about recreating the database each night?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning