Determine row size for table

dbcc showcontig ('YourTableNameHere') with tableresults

SELECT * FROM INFORMATION_SCHEMA.COLUMNS

SELECT OBJECT_NAME (id) tablename
     , COUNT (1)        nr_columns
     , SUM (length)     maxrowlength
FROM   syscolumns
GROUP BY OBJECT_NAME (id)
ORDER BY OBJECT_NAME (id)