motioneye
asked on
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.