average row size....

• Marysa

  Ten Centuries

  Points: 1023

  More actions

  October 22, 2004 at 8:00 am

  #102245

  is there a command or storedproc that can tell me the average row size (in bytes) of a table...or even the byte size of the table itself?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  October 22, 2004 at 11:04 am

  #527698

  Task view in EM should give you table size. sp_help gives all columns. For varchar, select avg(len(col)) from the table.