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?
motioneyeAsked:
Who is Participating?
 
Aneesh RetnakaranConnect With a Mentor Database 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.