(Linchi Shea) Whenever this question comes up, my typical response is to pass along the following Microsoft recommendations: –The number of data files within a single filegroup should equal to the number of CPU cores. See the "Physical Database Storage Design" whitepaper. –Lining up the num
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help