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

**URL:** <https://forums.toadworld.com/t/huge-datasets-raised-arithmetic-overflow-error-on-toad-for-sql-server/60209>\
**Category:** Idea Pond\
**Created:** [November 19, 2024, 7:46pm UTC](https://forums.toadworld.com/t/huge-datasets-raised-arithmetic-overflow-error-on-toad-for-sql-server/60209 "2024-11-19T19:46:47Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![armando.reyes](https://avatars.discourse-cdn.com/v4/letter/a/919ad9/32.png) [@armando.reyes](https://forums.toadworld.com/u/armando.reyes)\
**Post date:** [November 19, 2024, 7:46pm UTC](https://forums.toadworld.com/t/huge-datasets-raised-arithmetic-overflow-error-on-toad-for-sql-server/60209/1 "2024-11-19T19:46:47Z")

</div>

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.