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