GilaMonster (3/15/2013)
MyDoggieJessie (3/15/2013)
so there's no difference between 2 files of 140GB and 4 files of 70GB, it's still 280GB total space.
To add to the above, remember that when adding multiple files to a single filegroup you are forcing SQL Server to stripe across the files. The overhead of maintaining the proportional fill and the constant file switching may actually have an adverse effect on the system.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉