Rough Umbraco node size estimation

umbraco_node_size.sql

select un.uniqueId, cv.nodeId, cv.id as versionId, totalVersionSize.totalValueSize, versionPropertyCount.propAmount
FROM umbracoContentVersion cv
left join (
SELECT versionId, Sum(
	(coalesce(DATALENGTH([intValue]),0)
	+coalesce(DATALENGTH([decimalValue]),0)
	+coalesce(DATALENGTH([dateValue]),0)
	+coalesce(DATALENGTH([varcharValue]),0)
	+coalesce(DATALENGTH([textValue]),0)))
	AS totalValueSize 
FROM umbracoPropertyData
group by versionId
) as totalVersionSize on totalVersionSize.versionId = cv.id
left join (
select pd.versionId, count(distinct pd.id) as propAmount
FROM umbracoPropertyData pd
group by versionId
) as versionPropertyCount on versionPropertyCount.versionId = cv.id
left join umbracoNode un on un.id = cv.nodeId
order by totalVersionSize.totalValueSize desc

select un.uniqueId, cv.nodeId, cv.id as versionId, totalVersionSize.totalValueSize, versionPropertyCount.propAmount
FROM umbracoContentVersion cv
left join (
SELECT versionId, Sum(
	(coalesce(DATALENGTH([intValue]),0)
	+coalesce(DATALENGTH([decimalValue]),0)
	+coalesce(DATALENGTH([dateValue]),0)
	+coalesce(DATALENGTH([varcharValue]),0)
	+coalesce(DATALENGTH([textValue]),0)))
	AS totalValueSize 
FROM umbracoPropertyData
group by versionId
) as totalVersionSize on totalVersionSize.versionId = cv.id
left join (
select pd.versionId, count(distinct pd.id) as propAmount
FROM umbracoPropertyData pd
group by versionId
) as versionPropertyCount on versionPropertyCount.versionId = cv.id
left join umbracoNode un on un.id = cv.nodeId
order by versionPropertyCount.propAmount desc