We have one table with about 120 columns in it. I was just curious what the average row size was, and found this slick solution:
Use DBCC to find the “Average Size of a Row”
dbcc showcontig (‘your_table_name‘) with tableresults
My tablename=’Transaction’, so substitute your tablename there.
dbcc showcontig (‘Transaction’) with tableresults
Useful columns in the result are: AverageRecordSize, MinimumRecordSize, MaximumRecordSize