Recently, I was doing research on memory optimized table and I found that most of the data types are supportive and few of them are non supportive as well. But even though few data data types are non supportive there are works around to deal with those data types as well. In my earlier article, I wrote about how to deal with BLOB data types even though they are non supportive. Rest of the non supportive data types work around, I will share in my upcoming posts.
Given below is the list of Supportive data types:
- bigint
- int
- tinyint
- smallint
- int
- real
- smallmoney
- money
- float
- decimal
- numeric
- bit
- uniqueidentifier
- smalldatetime
- datetime
- binary
- nchar
- sysname
Given below is the list of Non-supportive data types:
- image
- text
- sql_variant
- ntext
- varbinary(Max) (Limitation is 8060 bytes per row)
- varchar(Max) (Limitation is 8060 bytes per row)
- timestamp
- nvarchar(Max) (Limitation is 8060 bytes per row)
- xml
Let me know if you have work around for the non supportive data types.
SQL Server Portal 