The importance of filegroups in database performance
In this post I would like to explain you with a hands-on example the importance of filegroups in Sql Server databases.
This is not a post that experienced/advnanced DBAS/developers should read. The target audience is beginners (Level 100).
Most beginners in SQL Server do not understand the concept of filegroups and why we need them.
Ι am going to start with a short introduction on data files,log files. (
read more)