Describe how filegroups are used in a database.
What will be an ideal response?
Data files are placed into filegroups for storage management. Each database must have a primary filegroup with at least one data file. However, a database may have more than one data file in a filegroup; the database is able to use all the data files concurrently, which can improve performance. If using more than one data file within a filegroup, the data files should all be the same size as the database attempts to fill them equally.
Computer Science & Information Technology
You might also like to view...
To change the format of a field, you should use the Property Sheet window
Indicate whether the statement is true or false
Computer Science & Information Technology
Google Drive includes cloud storage and ________ to store, work with, and share files
A) web apps B) libraries C) distro D) compression tools
Computer Science & Information Technology