Table size: select databasename ,tablename ,cast(sum(currentPerm) / (102410241024) AS DECIMAL(7,2)) as "CurrentPerm in GB" ,cast(sum(PeakPerm) / (102410241024) AS DECIMAL(7,2) )as "PeakPerm in GB" from dbc.tablesizev where databasename = 'T_UAT_LZ_GWPOLICYCENTER_PS' and tablename= '' group by 1,2;