title: How to estimate the data size from a particular query result
body: <p>I want to estimate on the actual data size of a query result. For example, I want to know how big the dataset is for all records from this table that is less than 4 year old with the following query in SQL server</p>
  
  <pre><code>select * from dbo.MY_TABLE
  where ETL_CREATE_DTM &gt; dateadd(year, -1, getdate());
  </code></pre>
  
  <p>How exactly do I get the size of the query result, in MB or GB not the number of rows?</p>