We have one table with about 120 columns in it. I was just curious what the average
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
Filed under: SQL