Complicated size calculation
-
All, I have a slightly complicated issue, I have a Sql 2005 DB which is like 20GB right now, It has different tables related like Projects->Facilities->Locations->Pictures What I am looking for is the size occupied by an individual project, Lets say Projects Table has the following 1 Sample Project One 2 Sample Project Two Facilities has the following 1 1(ProjectId) Facility One 2 1(ProjectId) Facility Two 3 2(ProjectId) Facility Three and Locations and pictures are related similarly using FacilityId and LocationId Now I need the data occupied by the entire Project One including the data related to Project One in all other tables. Hope this is clear, I welcome any suggestions, Thanks in advance
-
All, I have a slightly complicated issue, I have a Sql 2005 DB which is like 20GB right now, It has different tables related like Projects->Facilities->Locations->Pictures What I am looking for is the size occupied by an individual project, Lets say Projects Table has the following 1 Sample Project One 2 Sample Project Two Facilities has the following 1 1(ProjectId) Facility One 2 1(ProjectId) Facility Two 3 2(ProjectId) Facility Three and Locations and pictures are related similarly using FacilityId and LocationId Now I need the data occupied by the entire Project One including the data related to Project One in all other tables. Hope this is clear, I welcome any suggestions, Thanks in advance
Never having addressed this requirement this is a guess only. I would take a look at the properties in SSMS, I'm sure the tables have size and rowcount in their properties, this means it is stored in a sys table somewhere. It now becomes a search and mathematics problem. Good Luck
Never underestimate the power of human stupidity RAH