Friday, June 10, 2016

SQL Server Management Studio: check size of tables

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!

Subscribe to RSS Feed Follow me on Twitter!