You can get that in Paperback (USA) and Kindle (Worldwide).
There are many advantages to using filegroups to manage the database workload. A filegroup may contain many datafiles, and the properties of all the datafiles can be managed simultaneously with a filegroup. There are many advantages to using filegroups to manage the database workload. A filegroup may contain many datafiles, and the properties of all the datafiles can be managed simultaneously with a filegroup.
A primary filegroup contains the primary datafile (mdf) and possibly secondary datafiles (ndf). All system tables are allocated to the primary filegroup.
A secondary filegroup (also called a user-defined filegroup) contains secondary datafiles (ndf) and database objects.
The default filegroup contains objects which were created without an assigned filegroup. The primary filegroup is the default filegroup unless another filegroup is specified.
SQL in Sixty Seconds Video
We have attempted to explain the same subject in simple words over in following video.
[youtube=http://www.youtube.com/watch?v=1M1dJ4MeA3U]
Action Item
Get the book for yourself and your friend. This is just a reference everyone must have it.
Read the related blog post: SQL Basics: What Are Filegroups – Day 9 of 10
Available in Paperback (USA), Kindle (Worldwide)
Reference: Pinal Dave (https://blog.sqlauthority.com)
