Are there any specific guidelines to split up a single MDF file into multiple files for a single database. An example of a scheme that I can think of is splitting it so that one NDF file contains just indexes and another just the tables which take Insert operations, another one that has large tables etc, so the scheme would look something like:
- MDF containing smaller tables
- NDF containing indexes
- NDF containing larger tables
- NDF containing tables optimized for insert operations
Also, all these files would be on separate drives.