What is the purpose of creating a filegroup?

What is the purpose of master DB?

The master database records all the system-level information for a SQL Server system. This includes instance-wide metadata such as logon accounts, endpoints, linked servers, and system configuration settings.

What is the purpose of secondary data file?

Secondary data files are optional and can be used to spread data across multiple files/disks by putting each file on a different disk drive. SQL Server databases can have multiple data and log files, but only one primary data file.

What is the benefit of using filegroups?

The big benefit of filegroups is to separate database objects. You can put one table or a set of tables on one FG, and indexes on another, or some other configuration. You can also choose to put large object data on its own FG.

Why would you specify a particular filegroup for a table?

There are two primary reasons for creating filegroups: performance and recovery. Filegroups that contain files created on specific disks can alleviate disk performance issues. For example, you may have one very large table in your database with a lot of read and write activity – an orders table, perhaps.