CREATE TABLE [dbo].BlobTable
(
	[Col_PK] [int] IDENTITY(1,1) NOT NULL,
	[Col_ParentValue] [int] NULL, 
	[Col03] [varchar](100) NULL,
	[Col04] [int] NULL,
	[Col05] [varchar](200) NULL,
	[Col06] [smallint] NULL,
	[Col07] [smallint] NULL,
	[Col08] [smallint] NULL,
	[Col09] [smallint] NULL,
	[Col10] [int] NULL,
	[Col11] [int] NULL,
	[Col12] [int] NULL,
	[Col13] [varchar](255) NULL,
	[Col14] [varbinary](max) NULL,
	[Col15] [varbinary](max) NULL,
	[Col16] [varbinary](max) NULL,
 CONSTRAINT [PK_BlobTable] PRIMARY KEY CLUSTERED ([Col_PK])
) 
-- есть ещё несколько индексов, которые я не привожу для экономии места. 

CREATE view [dbo].[v_TableSpaceUsage] 
as
-- from sp_spaceusage
select 
[Schema_Name],
Table_Name,
[rowCount] as RowsCnt,
cast((reservedpages * 8) / 1024.0 as decimal(18,1))  as ReservedMB,  
cast((pages * 8) / 1024.0 as decimal(18,1)) as DataMB,
pages as PagesCnt,
index_sizeMB =  cast((CASE WHEN usedpages     > pages     THEN (usedpages - pages)         ELSE 0 END * 8) / 1024.0 as decimal(18,1)),
unusedMB =      cast((CASE WHEN reservedpages > usedpages THEN (reservedpages - usedpages) ELSE 0 END * 8) / 1024.0as decimal(18,1))

from
( 
 SELECT 
        s.name as [Schema_Name],
        object_name(p.object_id) Table_Name,
		reservedpages = SUM (reserved_page_count),
		usedpages = SUM (used_page_count),
		pages = SUM (
			CASE
				WHEN (index_id < 2) THEN (in_row_data_page_count + lob_used_page_count + row_overflow_used_page_count)
				ELSE lob_used_page_count + row_overflow_used_page_count
			END
			),
		[rowCount] = SUM (
			CASE
				WHEN (index_id < 2) THEN row_count
				ELSE 0
			END
			)
	FROM sys.dm_db_partition_stats p
	join sys.objects o on p.object_id=o.object_id and o.type in ('U') 
	join sys.schemas s on o.schema_id=s.schema_id
	group  by  s.name, p.object_id
 )T