Definitions
Sorry, no definitions found. You may find more data at filegroup.
Etymologies
Sorry, no etymologies found.
Support
Help support Wordnik (and make this page ad-free) by adopting the word Filegroup.
Examples
-
Filegroup, File and FileStream shapper posted on Monday, September 13, 2010 12: 20 PM
-
Filegroup, File and FileStream shapper posted on Monday, September 13, 2010 12: 20 PM
-
Filegroup, File and FileStream shapper posted on Monday, September 13, 2010 12: 20 PM
-
So you're working here with the Filegroup, not the files.
MSDN Blogs 2009
-
So you're working here with the Filegroup, not the files.
MSDN Blogs 2009
-
Slide 106: 80 CHAPTER 4 s BACKING UP AND RESTORING FILES AND FILEGROUPS The Default Filegroup If you don't specify any filegroup when creating an object, it will be placed on a default filegroup.
-
Creating an Object in a Filegroup To specify a filegroup, you simply add an ON clause to the end of the CREATE statement: CREATE TABLE AWNotes ([ID] INT, [Notes] TEXT) ON AWSampleData In addition to placing tables and indexes on specific filegroups, you can specify a separate filegroup to hold any data for columns of type TEXT, NTEXT, or IMAGE.
-
Filegroup Strategies BOL states, "Most databases will work well with a single data file and a single transaction log file."
-
Slide 106: 80 CHAPTER 4 s BACKING UP AND RESTORING FILES AND FILEGROUPS The Default Filegroup If you don't specify any filegroup when creating an object, it will be placed on a default filegroup.
-
Associating new files with a filegroup When adding a file to a filegroup, the Filegroup column shows only filegroups that you've created already.
Comments
Log in or sign up to get involved in the conversation. It's quick and easy.