Simplifying the post hoping to get answer:

We have a 3rd party vendor table with following definition: 7 non-sparse columns and 340 varchar(max) sparse columns:

CREATE TABLE [dbo].[ReportSparseData](

[ReportSparseDataId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,

[ReportMainId] [int] NOT NULL,

[ReportYearId] [char](2) NOT NULL,

[UserId] [int] NOT NULL,

[DateAdded] [datetime] NOT NULL,

[DateLstMod] [datetime] NOT NULL,

[ts] [timestamp] NOT NULL,

[C1] [varchar](max) SPARSE NULL,

[C2] [varchar](max) SPARSE NULL,

[C3] [varchar](max) SPARSE NULL,

[C4] [varchar](max) SPARSE NULL,

[C5] [varchar](max) SPARSE NULL,

[C6] [varchar](max) SPARSE NULL,

--

--

--

[C339] [varchar](max) SPARSE NULL,

[C340] [varchar](max) SPARSE NULL,

CONSTRAINT [Pk_ReportSparseData_[ReportSparseDataId] PRIMARY KEY CLUSTERED

(

[ReportSparseDataId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

-------------------------------------------------------------------

Question 1: What would be the row size for this table definition?

-------------------------------------------------------------------