InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 04:36:44 GMT20http://www.sqlservercentral.com/Forums/Topic1428447-1550-1.aspxI 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. [code="sql"]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[/code]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.Tue, 19 Mar 2013 23:17:56 GMTMac1986http://www.sqlservercentral.com/Forums/Topic1428447-1550-1.aspxHi I wanted to know if there is a way to figure out how many bytes of data have been processed while performing the delta on a table. I can easily get the delta count of every delta job run, but I'm not aware if there is a way to figure out how many bytes are processed based on the delta row counts or other. We use Informatica for our ETLs if this helps to get the delta data volume info.Please help and suggest of all possible ways to get this info.Fri, 08 Mar 2013 01:57:44 GMTMac1986