In MS SQL, checking / monitoring size of tables is important to manage spaces and optimize SQL performance.
You can use a SQL script in this article, but also some easier ways in SQL Server Management Studio (SSMS). You can do as one of the following way:
1. Right click on the database, select
Reports > Standard Reports > Disk Usage By Table
2. Or press
F7 to view
Object Explorer Details, navigate to
Tables view, then right click on the header and select
Data Space Usage column:
You can sort on the column.
Happy working!
