Solved

Table filegroup and Text Filegroup

Posted on 2006-07-02
2
698 Views
Last Modified: 2010-05-18
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
Comment
Question by:motioneye
2 Comments
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 250 total points
ID: 17028741
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
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 17028973
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sql server stored procedure parameter 10 20
disk usage reporting tools 27 48
sql query 5 37
Split string into 3 separate fields 5 18
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question