Definitions
from Wiktionary, Creative Commons Attribution/Share-Alike License.
- noun Plural form of
filegroup .
Etymologies
Sorry, no etymologies found.
Support
Help support Wordnik (and make this page ad-free) by adopting the word filegroups.
Examples
-
Examples in many sources, including BOL, label filegroups with no particular meaning (e.g.,
-
Examples in many sources, including BOL, label filegroups with no particular meaning (e.g.,
-
Examples in many sources, including BOL, label filegroups with no particular meaning (e.g.,
-
Indexes, data, should be on separate filegroups and filegroups should be spread on physical disks.
Scaling SQL Server 2005 & National TV (USA, Canada) « The Paradigm Shift 2006
-
Second, don't do this with a large database - the possibility of multiple files in the filegroups on a complex database is high, and you might not get them all.
-
Second, don't do this with a large database - the possibility of multiple files in the filegroups on a complex database is high, and you might not get them all.
-
But all filegroups are present in a single SAN disk.
-
As you mentioned, it does have it's limitations so the choice of storage isn't straightforward. e.g. Database Mirroring isn't supported and database snapshots don't work with FILESTREAM filegroups.
-
Handy script to get the filegroups and other information for partitioned tables
MSMVPS.COM Simons SQL Blog 2010
-
This little script gives you the filegroups for each partition in a partitioned table.
MSMVPS.COM Simons SQL Blog 2010
Comments
Log in or sign up to get involved in the conversation. It's quick and easy.