Sum of size of set of tables in Megabytes

• Saronabound

  Mr or Mrs. 500

  Points: 525

  More actions

  February 7, 2012 at 6:47 am

  #251037

  I need to get a sum of the size of a certain set of tables in megabytes. I know I can use sp_spaceused, and use a cursor to loop through the tables, but the results comes back something like '2046 KB'.

  I guess I could use substring and patindex to strip off the 'KB' and then convert the varchar to a number, but if anyone else has a good way to get the total sum of bytes for a list of tables I would like to see it.

  Thanks,

  Keith

• HowardW

  One Orange Chip

  Points: 29109

  More actions

  February 7, 2012 at 7:52 am

  #1443790

  Use the DMV sys.dm_db_partition_stats instead, then it's much easier to tweak.

  If you want a complete solution, already built, I quite like this one:

  http://www.rmjcs.com/SQLServer/DMVs/sysdm_db_partition_stats/tabid/55/Default.aspx