title: Calculate amount of disk space used by results of a T-SQL query
body: <p>I am comparing SQL Server with another database technology, and in order to compare disk requirements I would like to calculate the amount of disk used by only the elements returned by a SELECT query that JOINs over a few tables with a simple WHERE clause, rather than for a whole table or database. This is so that I don't have to go to the trouble of loading an entire table or database worth of data into the other database.</p>
  
  <p>I have a query like the following that I'd like to do this for:</p>
  
  <pre><code>SELECT * FROM a
  INNER JOIN b ON a.id = b.id
  INNER JOIN c ON a.id = c.id
  INNER JOIN d ON a.id = d.id1 OR a.id = d.id2
  WHERE a.id = 390330
  </code></pre>
  
  <p>I haven't been able to find any advice online, other than how to find the disk space used by an entire table or database. Is there anything built into SQL Server that can help me, or will I need to calculate this by hand?</p>