Suresh Kumar M

When we are working with SQL Server databases, very often we will come across the problem of abnormal database size growth. In such a situation we need to get the size of tables in the database to identify the abnormal sized tables to figure out the cause of growth. _______________________________________________________________________________________________________________________ Here we will go through some of the easiest methods to get the size of all the tables in a database. This will help you to identify the tables with abnormal size. _______________________________________________________________________________________________________________________ 1. Find Size Of Tables Using SSMS Standard Report The easiest way to find the size of all the tables in a database is to use the SQL Server Management Studio’s (SSMS) standard report called Disk Usage by Table. To access the disk usage table: ________________________________________________________________________________