Find Largest size Tables in a Database...

You will find a stored proc for this here : https://www.sqlservercentral.com/scripts/Administration/63646/