Forum Discussion
Data Types uncompressed storage size
Hi Brown ,
Maybe a similar thread can help you a bit.
how to determine uncompressed table size in Desktop
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-xuding-msft ,
Thanks for you reply. I had read that post (incidentally that poster didnt recieve an answer to his question) as well as other posts related to uncompressed data issues. I have also done my own testing/research before coming to the forums. The standard answer is to normalise data, remove columns etc, which isn't the point.
The issue is we have a limit applied, but no tools to monitor if we are approaching that limit. We can only do theoritical calculations or upload lots of data until we get an uncompressed data related error message.
Is there not some documentation Microsoft could provide on how table size is calculated on load? Given most data is int64 or fixed decimal is it 8 bytes * number of records? or does it also depend on the integer value?
Regards,