June 7, 2016 at 10:51 am
Ed Wagner (6/7/2016)
There are a whole bunch of restrictions for memory-optimized tables and most of them that I remember are about performance. It prevents us from creating tables that are going to be slow by design. Granted, all my knowledge is theoretical because I've seen PASS presentations on it, but we're nowhere near getting SQL 2016 in-house. Even if we did, it takes EE anyway and I'm not that fortunate.
Agree, and I work more on SE rather than on EE.
See the reply above, I tried with nvarchar(400) (let's say for tiny JSON structures), it's still restricted.
Igor Micev,My blog: www.igormicev.com
July 13, 2016 at 2:39 pm
50/50 chance and I got it. Interesting info for the new feature.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 2 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply