When we are working on performance factor of database at that time table space and size will matter , generally we are not think about it in normally manner but when we have to optimize our database at that time we need to work on that . So here question is arise that

How can we check the tables occupied space and total space in MS SQL ?

So i want to share one query with you that might be help you lot , i was founded that query at other website . this query is very useful for those people who wants to get database size information ,I hope you will like and get something from it .

1) Connect with your sql server and database .

2) After that click on new query button, you can find it in the top menu .

3) Just write the below query and get your output .

Now just check your output , i hope you will get your output .


Still you have any issue then let me know , you can leave your comment or drop your mail at [email protected]

Kalpesh Sharma
StackBuddy from Kalpesh Sharma aims to help out bloggers & developer to become successful online. Stackbuddy is focus on several things like blogging tips, search engine optimization tips, make money online tips , SEO tips, job updates , programing tips and internet marketing tips for your online success.
How can we check tables size and used space in MS SQL was last modified: February 14th, 2016 by Kalpesh Sharma
Join StackBuddy Newsletter

Join StackBuddy Newsletter

Get Free Weekly Updates Via Email About Blogging Tips, SEO , Affiliate Marketing, Make Money Online & News from Stackbuddy.

You have Successfully Subscribed!

Leave a Reply

Your email address will not be published. Required fields are marked *

Join The StackBuddy Club !

Join The StackBuddy Club !

Enter your email address to subscribe to this blog & receive notifications of new posts by email

You have Successfully Subscribed!

Share This

Share this post with your friends!