Steve Jones - SSC Editor (5/24/2016)
I typically wouldn't expect more than one file in the primary filegroup, but there are certainly reasons to do this. Not sure you get benefits on the same drive like this, but it's not necessarily wrong. It is slightly complex, and unnecessary in most cases.
I don't believe that it was a design choice to have three files , but rather when the Database project was deployed to UAT by TFS this was how the database was created.
So I was wondering if anyone else had seen similar behavior when deploying a database project with TFS?