List objects with space used information
sys.dm_db_partition_stats: Returns page and row-count information for every partition in the current database. SQL Server Objects with space used https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-partition-stats-transact-sql?view=sql-server-ver15
