Memory Occupied by a table of a database
-
Hi , i want to know how can i get memory occupied by table of a database through query. if some one can provide me a google link where i can find it or the search string to be used for googling it out. it would be of great help. Also assume memory occupied by the table when no rows present is M , and when row is present the memory occupied is M*1, etc
-
Hi , i want to know how can i get memory occupied by table of a database through query. if some one can provide me a google link where i can find it or the search string to be used for googling it out. it would be of great help. Also assume memory occupied by the table when no rows present is M , and when row is present the memory occupied is M*1, etc
Use system database
sp_spaceused. Executing it without supplying parameters will return database size and with a table name gives it's size.All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia How to use google | Ask smart questions