I have got this script from old post of Gail. I have few small questions on this. Please let me know so that i can start using this for my operational purposes.
create table ##tmp (TableName varchar(100),DefinedRowSize int)
exec sp_msforeachtable 'INSERT INTO ##TMP Select ''?'' As TableName, SUM(C.Length) as Length from dbo.SysColumns C (NOLOCK) where C.id = object_id(''?'')'
select TableName,DefinedRowSize from ##tmp order by TableName
1) What is DefinedRowSize ?
2) How is the calibration of DefinedRowSize MB? OR KB? OR Bytes?
I'm actually trying to calculate size of few selective records from a table.