SqlServer-QA.net

Filegroups use a proportional fill strategy across all the files within each filegroup. As data is written to the filegroup, SQL writes an amount proportional to the free space in the file to each file within the filegroup, rather than writing all the data to the first file until full, and then writing to the next file.   Using ...