sql server - Determine row size for table

Question

How to I determine the maximum row size for a table? I'm looking for a tool or script that does this so I don't have to add up each column's size by hand.

My goal is to produce a report of tables that are too wide so we can look into restructing them. I know we have several that are so wide that only 1 row fits on each 8K page, but I want to find the rest.

Answer 1

Another way, run this then look at MaximumRecordsize

dbcc showcontig ('YourTableNameHere') with tableresults