With this simple query, you can find size of all tables on sql database
EXEC sp_MSforeachtable @command1=”EXEC sp_spaceused ‘?'”
otherwise if you need to check a single table
you can use the following query
exec sp_spaceused tablename;
Lavatelli IT Blog Site