I have a database with a single file which size is 288GB.
I'm dropping the indexes and the data is only 90GB. I added three more files and re-created the dropped indexes. Data is equally distributed on the three files and reaches about 66GB on each. In future all four files will have same size.
There is also possibility to remove the data, and then insert it again, but that is the harder option, and much time consuming. So in that case I can have all four files with equal size -288/4 = 72GB. My situation is 90GB,66GB,66GB,66GB.
I know it is important for the tempdb data files' initial sizes to be equal and with same autho-grow configuration.
Does it matter with the user-database data files? I think no. Anyone against, with suggestion, or to confirm ..you're welcome.
Thanks in advance,
SQL Server developer at Seavus