Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Text Filegroup, Filegroup and Filestream filegroup. What's the difference?

Posted on 2014-01-02
1
372 Views
Last Modified: 2014-01-04
Most of all, I'm not clear on the distinction between Text Filegroup and the other two.

I understand that a 'standard' filegroup can hold user and system data, and that ideally a secondary filegroup should be created and set as default to separate user data from system tables. I also understand that BLOB data in filestream columns will be stored in the filestream filegroup. But where does Text Filegroup come in?
0
Comment
Question by:TimHudspith
1 Comment
 
LVL 52

Accepted Solution

by:
Carl Tawn earned 500 total points
ID: 39753421
The Text Filegroup is a filegroup used to store large columns with an undefinded size (such as BLOB, varchar(MAX), etc) in a filegroup separate from the main table. You specify it when you create the table using the TEXTIMAGE_ON clause. It's an optional thing though, you don't have to use it - and i don't remember having come across anybody actually using it.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
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…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

860 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