Calculating the average row length
Posted on 2001-07-04
I am trying to conduct a sizing exercise for my database. I am using the tried and tested approximation that a table size is approx = num rows * average row length.
The problem is that I am struggling to figure out the average row length for the table(s). From business predictions I can figure out the number of rows but without the avg row length I'm stuffed.
I know in Oracle I can (after running stats) select DBA_TABLES.AVG_ROW_LENGTH for just this thing - is there an easy way in SQL Server. I have a development database which I can use for test data if only I can figure out how to do it.
Can anybody help