Post reply

Size of a row

  • July 19, 2011 at 3:59 am

    #241666

    I can check the size of a table with sp_spaceused. Can we check the size row wise ? May help me in case where LOB datatypes are used.

  • July 19, 2011 at 5:05 am

    #1354711

    Use datalength(columnname) and then add all those to get the sum of the row.

  • July 22, 2011 at 1:16 pm

    #1357268

    The DMV, dm_db_index_physical_stats, also shows the min, max and average row size as min_record_size_in_bytes, max_record_size_in_bytes and avg_record_size_in_bytes.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply