Hello all,

I found that number of columns further influenced the rows/page density thinking (sometimes for legacy support reasons we needed to keep an 'award-winningly' de-normalised table)

Small addition to SSC Journeyman's post:

select OBJECT_NAME(so.id) as tablename, rowcnt as row_count, dpages as page_count, rowcnt/dpages as rows_per_page, COUNT(sc.name) as num_columns

from sysindexes si left outer join sysobjects so on si.id = so.id left outer join syscolumns sc on si.id = sc.id

where si.indid = 1 and so.xtype = 'U' and rowcnt > 0

group by OBJECT_NAME(so.id), rowcnt, dpages, rowcnt/dpages

order by num_columns desc, rows_per_page

Thanks !

(this syntax is good for 2000, 2005, 2008)