query get total records length on aql query code example
Example 1: how to get the particular record size in table
dbcc showcontig ('YourTableNameHere') with tableresults
Example 2: how to get the particular record size in table
SELECT * FROM sys.dm_db_index_physical_stats (DB_ID(N'AdventureWorks2014'), OBJECT_ID(N'[sales].[SalesOrderHeader]'), NULL, NULL , 'DETAILED')