data-konzept

'Question: I’d like to understand if there is a way in SQL Server to estimate the size of a sql result set in kilobytes (KB)? Is there some sort of statistic returned which associates a size statistic to a result set?

Answer: The first thing is to consider is that size is not a property of data. This means we need to use various calls to methods which supply the data.'...

http://www.sqlserver-dba.com/2015/11/how-to-calculate-the-size-of-sql-results-in-kb.html