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)