SELECT DatabaseName, TableName                 
 
,CAST(SUM(CurrentPerm) /1024**3 as DECIMAL (6,0)) AS ActualSpaceGB
 
,CAST(MAX(CurrentPerm)*(HASHAMP()+1) /1024**3 as DECIMAL (6,0)) as EffectiveSpaceGB
 
,EffectiveSpaceGB-ActualSpaceGB AS WasteSpaceGB
 
,CAST(100*(((MAX(CurrentPerm)*(HASHAMP()+1) /1024**3)-(SUM(CurrentPerm) /1024**3))/ (MAX(CurrentPerm)*(HASHAMP()+1) /1024**3)) as DECIMAL (6,0)) AS "WasteSpace%"
 
,CAST((100 - (AVG(CurrentPerm)/MAX(CurrentPerm)*100)) as DECIMAL (6,0)) AS SkewFactor
 
FROM DBC.TableSize
 
WHERE DatabaseName='<Database Name>'
 
GROUP BY 1,2
 
ORDER BY 5 DESC

U0VMRUNUIERhdGFiYXNlTmFtZSwgVGFibGVOYW1lICAgICAgICAgICAgICAgICAKIAosQ0FTVChTVU0oQ3VycmVudFBlcm0pIC8xMDI0KiozIGFzIERFQ0lNQUwgKDYsMCkpIEFTIEFjdHVhbFNwYWNlR0IKIAosQ0FTVChNQVgoQ3VycmVudFBlcm0pKihIQVNIQU1QKCkrMSkgLzEwMjQqKjMgYXMgREVDSU1BTCAoNiwwKSkgYXMgRWZmZWN0aXZlU3BhY2VHQgogCixFZmZlY3RpdmVTcGFjZUdCLUFjdHVhbFNwYWNlR0IgQVMgV2FzdGVTcGFjZUdCCiAKLENBU1QoMTAwKigoKE1BWChDdXJyZW50UGVybSkqKEhBU0hBTVAoKSsxKSAvMTAyNCoqMyktKFNVTShDdXJyZW50UGVybSkgLzEwMjQqKjMpKS8gKE1BWChDdXJyZW50UGVybSkqKEhBU0hBTVAoKSsxKSAvMTAyNCoqMykpIGFzIERFQ0lNQUwgKDYsMCkpIEFTICJXYXN0ZVNwYWNlJSIKIAosQ0FTVCgoMTAwIC0gKEFWRyhDdXJyZW50UGVybSkvTUFYKEN1cnJlbnRQZXJtKSoxMDApKSBhcyBERUNJTUFMICg2LDApKSBBUyBTa2V3RmFjdG9yCiAKRlJPTSBEQkMuVGFibGVTaXplCiAKV0hFUkUgRGF0YWJhc2VOYW1lPSc8RGF0YWJhc2UgTmFtZT4nCiAKR1JPVVAgQlkgMSwyCiAKT1JERVIgQlkgNSBERVND