Partitioning a table with TEXTIMAGE_ON option

Question

Partitioning a table with TEXTIMAGE_ON option

SSC Guru

Points: 173148

August 12, 2026 at 1:24 pm

I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to partition this table and I'm wondering if I can stick the blobs onto a separate filegroup / file while partitioning the rest of the data. Or do I have to put the blogs on the individual partitions?

Here's the sanitized version of my table before partitioning:

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[MyTable](
[COLUMN1] [bigint] NOT NULL,
[COLUMN2] [tinyint] NULL,
[COLUMN3] [varchar](255) NULL,
[COLUMN4] [varchar](MAX) NULL,
[COLUMN5] [varchar](100) NULL,
[COLUMN6] [varchar](30) NULL,
[COLUMN7] [varchar](255) NULL,
[COLUMN8] [varchar](10) NULL,
[COLUMN9] [varchar](255) NULL,
[COLUMN10] [datetime] NULL,
[COLUMN11] [datetime] NOT NULL,
[COLUMN12] [datetime] NULL,
[COLUMN13] [varchar](50) NULL,
[COLUMN14] [tinyint] NOT NULL DEFAULT (0),
[COLUMN15] [datetime] NULL,
[COLUMN16] [varchar](900) NULL,
[COLUMN17] [varchar](36) NULL,
[COLUMN18] [varchar](10) NULL,
[COLUMN19] [varchar](16) NULL,
[COLUMN20] [varchar](16) NULL,
[COLUMN21] [varchar](16) NULL,
[COLUMN22] [varchar](10) NULL,
[COLUMN23] [tinyint] NOT NULL DEFAULT (0),
[COLUMN24] [bigint] NULL,
[COLUMN25] [datetime] NULL,
[COLUMN26] [varchar](5) NULL,
[COLUMN27] [tinyint] NOT NULL DEFAULT (0),
[COLUMN28] [tinyint] NOT NULL DEFAULT (0),
[COLUMN29] [varchar](40) NULL,
[COLUMN30] [varchar](50) NULL,
PRIMARY KEY CLUSTERED 
(
[COLUMN1] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

That last line before GO, would I be able to say something like:

ON [PartitionScheme] (PartitionColumn) TEXTIMAGE_ON MyBlobFileGroup

Thoughts would be appreciated.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.