I think we're just reading the question differently. I read 'ALL queries' in the context of the database we don't want to use the new optimiser. If we changed all queries in that DB then we would only be using the old optimiser, which is what the question is asking.
Regards the use of memory optimised tables, I could just as reasonably say your point is invalid, Steve makes specific mention of using this functionality in the question, and it seems more of a reach for you to assume this is an exception that for me to assume it isn't.
I did read and comprehend the whole question, and I don't appreciate being called a troll. Reading a question differently to you, and having a different opinion doesn't make me a troll. It's also not inappropriate to post links to other people's blogs
Paul we are definitely reading the question differently.
However, you need to ask your self what the difference between these two sentences are. Be honest to yourself with the answer.
Sentence One - "I have upgraded my instance of SQL Server to 2014 to take advantage of memory-optimized tables."
Sentence Two - " If I do not want the cardinality estimatior to be used in a specific database, what can I do?"
One sentence is talking about an entire server instance, and another clearly states "a specific database".
If you were arguing that you can never turn off the CE, only the new CE that is in SQL 2014, I would be agreeing with you. However that is not the thing you posted to a thread that had nothing to do with you.
You are trying to tell me that Sentence One and Two above are talking about the same subject. They clearly are not and that is not interpretative. 😎