avg row size

• tulcanla

  SSCommitted

  Points: 1541

  More actions

  April 19, 2004 at 11:16 am

  #111050

  Hi  all,

   

  I need to detect the avg row size of some tables  for DBCC INDEXDEFRAG purposes, and

  apply 1.2*(avg rowsize)*(nr of rows)  formula...

  Do you know of a method? I have search the Interbnet and I found no code for SQL  except  for Oracle PL/SQL

  If you have any ideas, please help

   

  Thanks

  LMT

   

• roberthamilton

  Ten Centuries

  Points: 1002

  More actions

  April 20, 2004 at 2:41 am

  #503434

  You could try DBCC SHOWCONTIG(object_id)

  This will give you the number of pages occupied by the table, and the average page density. Knowing that each page is 8Kb, and given the number of rows in the table, you should be able to get an average number of bytes per row.

  Regards

  Rob