Collections:
What Is a SQL Server Filegroup
What Is a SQL Server Filegroup?
✍: FYIcenter.com
A SQL Server Filegroup represents a logical group of one or multiple physical Files.
Each Filegroup will be used as a single logical unit to allocate storage space
for database tables.
A SQL Server Database must have one Filegroup defined as the Default Filegroup, or Primary Filegroup.
The Default Filegroup must contain the Primary Physical File.
If you create a new table without specifying which Filegroup to use, it will be created on the Default Filegroup.
SQL Server Filegroup information is stored in a system table called sys.filegroups. Each record in this table represents a single SQL Server Logical Filegroup.
2019-07-14, 1383🔥, 0💬
Popular Posts:
How to valid IPv6 addresses? In order to help your programming or testing tasks, FYIcenter.com has d...
In what order thread groups are executed in JMeter? Thread groups, including regular "Thread Groups"...
How to call JMeter command in a Windows batch file? I want to create a single batch job to run JMete...
How to convert IPv4 to IPv6 addresses? In order to help your programming or testing tasks, FYIcenter...
How to update hidden input value field value with WebDriver in Python? Normally, a hidden input valu...