Posted by SQL on 12/05/80 11:30

This will give you the average length of all rows in your table
Just copy the proc and run it with your tablename in Query Analyzer

http://sqlservercode.blogspot.com/2005/09/average-length-of-all-rows-in-table.html

• Next in forum: Re: Deriving unique rows from historical data
• Prev in forum: Re: Record , Row number
• Thread view: Re: SQL Server 2000 and 8k limit

[Reply to this message]