Discover SQL Server Filegroup Separation Secrets: What and Why?

sql server filegroup

The default settings in SQL Server are not always the best. Such is the case when we are working with new user databases; usually we get a single data (*.mdf) and transaction log (*.ldf) file. The data file resides within the PRIMARY file group; the only one we have so far, and it will store … Read more