anushahanna
asked on
Find data size from syscolumns,sysobjectssys.partitions,columns
The following query brings the table's # of rows, but what join is needed to bring the data size also?
Thanks
Thanks
select isc.TABLE_SCHEMA,so.name,SUM(sc.length) AS ROW_SIZE_IN_BYTES,sp.rows as TotRows
from sysobjects so join syscolumns sc on so.name = OBJECT_NAME(sc.id)
join INFORMATION_SCHEMA.COLUMNS isc on sc.name=isc.COLUMN_NAME and so.name=isc.TABLE_NAME
join sys.partitions sp on OBJECT_NAME(sp.object_id)=so.name
where so.type = 'U' GROUP BY so.name, isc.TABLE_SCHEMA,sp.rows;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks.
Welcome..
ASKER