I am trying to figure out the disk size a number of rows in various tables take up.
I can define this rows by a query. How can I find out the actual disk size that corresponds to the result set in SQL Server?
The reason why I want to know this, is that I am trying to analyse a multi-tenant system. I am trying to get the total size each tenant takes up on the system. So I need the size of all rows pertaining to each tenant and the size each tenant is using in index tables, etc.
The tenants all share the same schema, so it is not easy to do.