How to calculate the size of a table in a database?

Question

SQL Server

The application needs to implement the deletion of data from the database for a certain period of time. At the same time, it is necessary to show how much data to delete, for example, if the user deletes data for the previous month, then X KB of space will be freed up.
I found a lot of Sql queries that consider the volume of the entire database and a specific table. But if you calculate the size of all databases and each table separately, they do not match.
Is it possible to somehow find out how much space will be freed up if I delete some of the data? Not in a specific table, but in the database, after recalculating the size of the database.

Answer 1

stackoverflow.com/questions/7892334/get-size-of-al...