Instead, let RAID 5 or RAID 10 do this for you automatically. In the long run, you will probably get better overall performance. More info from Microsoft . Be sure you don't put more than one table in the filegroup and that no other files exist on that disk array. By doing this, you can take advantage of the disk array's ability to operate sequentially to retrieve the data.
Sequential access is always faster than random access.
If your database is very large and very busy, multiple files can be used to increase performance . Here is one example of how you might use multiple files. Let's say you have a single table with 10 million rows that is heavily queried. If the table is in a single file, such as a single database file, then SQL Server would only use one thread to perform a sequential read of the rows in the table. In addition, if each file were on its own separate disk or disk array, the performance would even be greater.