SQL Server table sizes.
-
SS2008. Big database: 17GB total. The database has about 400+ tables. If I select a table, I can right-click it and select its properties and there's a Storage item I can click to get the size of the table. Is there some way I can do that for all tables without going through them one-by-one? I'd like to see where the bulk of the space is being used. Is it possible? EDIT: I found this[^] link which does what I'm looking for. Open a new query in SSMS and drop the code in the example shown in the link. It worked for me without any problem.
If there is one thing more dangerous than getting between a bear and her cubs it's getting between my wife and her chocolate.
-
SS2008. Big database: 17GB total. The database has about 400+ tables. If I select a table, I can right-click it and select its properties and there's a Storage item I can click to get the size of the table. Is there some way I can do that for all tables without going through them one-by-one? I'd like to see where the bulk of the space is being used. Is it possible? EDIT: I found this[^] link which does what I'm looking for. Open a new query in SSMS and drop the code in the example shown in the link. It worked for me without any problem.
If there is one thing more dangerous than getting between a bear and her cubs it's getting between my wife and her chocolate.
If you have Reporting Services (SSRS) installed, you can right-click on a database in SSMS and select Reports -> Standard Reports -> Disk Usage by Table or Disk Usage by Top Tables.
-
If you have Reporting Services (SSRS) installed, you can right-click on a database in SSMS and select Reports -> Standard Reports -> Disk Usage by Table or Disk Usage by Top Tables.
Thanks for that. I do have SSRS installed and it does have the report you described.
If there is one thing more dangerous than getting between a bear and her cubs it's getting between my wife and her chocolate.