Saturday, 30 July 2016

How to find the Disk Space Used by SQL tables ?

In SQL server management studio we have the option to view the Disk space used by the tables.

Select the Database --> Go to Reports --> Select Standard Reports --> Disk Usage by Top Tables as shown below.



Once you selected the above option the following report will appear, there you can see the total no of records and its disk space used by the tables


No comments:

Post a Comment