Solved

Calculating the average row length

Posted on 2001-07-04
1
1,169 Views
Last Modified: 2012-05-04
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
Comment
Question by:meowsh
1 Comment
 
LVL 18

Accepted Solution

by:
nigelrivett earned 200 total points
ID: 6253010
try sp_spaceused 'tablename'
gives no rows, data/index size
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL: launch actions one before the other 10 23
This query failed in sql 2014 5 30
Query Help - MSSQL - Averages 5 27
T-SQL:  Collapsing 9 23
I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question