Thank this author by sharing:
By suba sathyanathan,
Sometimes it might be difficult for find size of all tables since it involves calling sp_spaceused stored procedure against each table. This is still worse when the number of tables are huge. The attached script lists all tables with number of rows, reserved, actual data size, index size and unused space in a database.
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.