Sometimes you need to find database or tables sizes to find out what is taking the most disk space in a Microsoft SQL database server. Following two queries can be very handy in such case. Result looks following.
See queries below.
The first query will give you the size of your database in megabytes. And the second one will do the same, but break it out for each user created table in your database. Commenting out the line below the comment in the query would return size of each object in the database. That’s it!