December 23, 2019 at 6:21 pm
I was hoping to experiment with memory optimized tables for my staging layer to speed up the process. Googling "BIML Create Memory Optimized Table MEMORY_OPTIMIZED=ON" is not giving me nay results. This seems like it would be a common setting for a table used in a staging layer.
I am using the table.GetDropAndCreateDdl() code to create my scripts. I thought I could put the "MEMORY_OPTIMIZED=ON" after it but the function ends up creating a GO at the end.
The XML result
, [LoadDateTime] datetime2(7) NOT NULL
-- Constraints
)
ON "default"
WITH (DATA_COMPRESSION = NONE)
GO
-------------------------------------------------------------------
WITH (MEMORY_OPTIMIZED=ON)</DirectInput>
Thoughts?
December 24, 2019 at 7:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
December 24, 2019 at 7:42 pm
You cannot have DATA_COMPRESSION on memory optimised table, so there is no point in specifying it.
So remove that option and just leave: WITH (MEMORY_OPTIMIZED=ON)
December 25, 2019 at 2:11 am
I didn't add the compression statement, that is generated by the BIML code.
December 25, 2019 at 2:29 am
I didn't add the compression statement, that is generated by the BIML code.
Ok, sorry, I've never used BIML. Also I've only used memory optimised table once, and I found them slower than temporary tables so I gave up.
I would have thought there should be just one with WITH statement:
WITH (DATA_COMPRESSION = NONE, MEMORY_OPTIMIZED=ON)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply