If you’re using a GUI tool, such as SSMS to manage your databases, you can easily check the size of your database by clicking your way through the GUI (right-click the database, point to Reports, then Standard Reports, and then click Disk Usage).

However, if you prefer to use T-SQL to manage your databases, you’ll need to run a query to find all databases sizes.

Query to find all databases sizes, ssms union-vs-union-all

The article was published on October 30, 2019 @ 8:49 PM

Leave a Comment