Row size in bytes

Question

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

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

Roi Assa SSChasing Mays Points: 611 More actions · Answer 1

One way to find this information is:

DBCC SHOWCONTIG (Table_Name) WITH TABLERESULTS

Kindest Regards,

Roi Assa

okie_greg SSC Eights! Points: 911 More actions · Answer 2

This will get the maximum possible rowsize for the employees table in the pubs database:

select sum(sc.length)

from sysobjects so

join syscolumns sc on so.id = sc.id

where so.name = 'employee'

and so.xtype = 'U'

This is not the maximum actual row length, but the maximum possible (i.e. every varchar column is maxed out in the row).