We often run out of the space in our drive and that is the number 1 cause of SQL Server engine stop running on various machines. Quite often we wonder how much space if any of the objects takes in the database. It is very simple to find out the space used by any table in the database.
USE AdventureWorks; GO EXEC sp_spaceused 'Sales.Customer'; GO
You can run above script to find the space in your database. It also shows how many rows are there in each table along with the size of the index as well, which can be very much useful.
Here are few additional blog posts related to this subject which I encourage you to read it.
If you know any other trick which we can all find useful, I suggest that you send me email and I will publish it with due credit.
Reference: Pinal Dave (https://blog.sqlauthority.com)