[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1184
  • Last Modified:

Calculating the average row length

Hello experts,

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

Regards, Meowsh
0
meowsh
Asked:
meowsh
1 Solution
 
nigelrivettCommented:
try sp_spaceused 'tablename'
gives no rows, data/index size
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now