Huge datasets raised 'Arithmetic overflow error" on Toad for SQL Server

When working with huge datasets (Terabyte sizes) Toad for SQL Server might trigger the Arithmetic overflow error. Compressing the partitions solves the issue temporarily until the next possible growth. A permanent solution is needed.