• I have designed a few tables that we expected to be very actively inserted/deleted against and grow as the business grows. In these cases I created each table on it's own filegroup/file to start with.

    When first rolling out the features we were able to place them on existing drives. As i/o performance and capacity needs increased for any of the tables it was a quick offline operation to move the file to dedicated drives.