sextonk (12/23/2014)
It is my understanding that is a best-practice. To have multiple data files which are the same size.
It is, for TempDB and only for TempDB. It is not, and never has been, a recommendation for user databases.
Deciding on file splits for user databases are far more complex and should not be done without first deciding why (performance or partial backup/restore are the usual reasons), testing to ensure that the design meets the requirements and doing sufficient monitoring and analysis to ensure that the changes are necessary in the first place.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability