I have inherited a SQL Server 2005 database that is 400GB in size with 300GB of data on one data file on a RAID 10 disk and a second 100GB data file with indexes only on another drive. The log is on a separate drive as well. I would like to split the data data file into multiple files and the index data file into multiple files potentially to span different disks to achieve parallel i/o. I believe this can be accomplished with the creating several data files then using the empty file command or by using the restore method with move. Does anyone have any insights into a "best solution" method? Thanks.