Forum Discussion
Evaluation of the storage dimension for a warehouse table row
Hi pmscorca,
>>Fabric using the delta format doesn't improve or reduce the storage size occupied by a data type, isn't it?
For existed data type, they should be similar to the SQL database. The other type which does not support (e.g. datetime2), you may need to use other type (timestamp 8 bytes)to instead. They should base on the byte size difference between old type and replaced new data type.
Solved: Data types in Delta - Microsoft Fabric Community
Regards,Xiaoxin Sheng
HI pmscorca,
AFAIK, common ASCII characters will oppcute 1 byte per character with 2 bytes for length information, so the varchar(10) should use more storage space.
Also datetime format should more suitable for usages, if you are stored them in string field, you may need to do transform before use date functions on this type of field.
Regards,
Xiaoxin Sheng
Hi, thanks for your reply but it is not very clear for me.
Ok, for the size related to a varchar(n) column.
But for a datetime2() column? Fabric supports datetime2 and not datetime.
And the size for an int column?
Data types in Microsoft FabricHi pmscorca,
The datetime2 data type in SQL Server can occupy between 6 to 8 bytes based on its milisecond precision that user defined.
datetime2 (Transact-SQL) - SQL Server | Microsoft Learn
Storage size:
6 bytes for precision less than 3.
7 bytes for precision 3 or 4.
All other precision require 8 bytes.Regards,
Xiaoxin Sheng
Hi, thanks for your reply.
I've read that the int type require 4 bytes.
I've already known these sizes related to SQL Server, but for a Fabric warehouse?
Fabric uses delta format.Thanks
