Partitioning a table with TEXTIMAGE_ON option

• Brandie Tarvin

  SSC Guru

  Points: 173146

  More actions

  August 12, 2026 at 1:24 pm

  #4927566

  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.