This is the 9th post out of my 10 post series of my videos on my 10th book – SQL Basics. Today will show the importance of data and information.
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)
