• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 718
  • Last Modified:

Table filegroup and Text Filegroup

Hi,
What's the difference between Table filegroup and Text Filegroup? can i say that table filegroup is the table use to save database records? and how about text filegroup?
0
motioneye
Asked:
motioneye
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
The table filegroup is where the table is stored, the text filegroup is where text or image type data (i.e. binary data  like Word or JPEG files) in the table are stored .
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
to add to the explanation:
in sql server, short values of TEXT data can be store inline in the table filegroup, while longer text value will be store in the text  filegroup, and in the row itself will only be stored a pointer value. This will be transparent for the SQL using the values.

This "splitting" is used for better managibility of the ususally rather large TEXT database parts, to be able to configure backups in a more easy way.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now