SQL Server 2014 CTP 2 will be abandoned due to pre-release with too many data querying restrictions and wonky compiled stored procedures
SQL Server 2014 CTP is not a production release so I need to be fair on this.
1. Too many restrictions at this point for use with OLTP in memory for both inserting and selecting. There are too many list here
2. Converting current tables to be optimized for OLTP in memory is a real pain let alone understanding. No constraints allowed and no auto identity indexing as well.
3. The compiled stored procedures are a real bitch to build. I am sure there will be better capabilities to build them through a GUI but what pain as is.
Is it worth it? Maybe but not at this point so I put a lot of hype into it. A couple of days worth of work is now been wasted. I have been forewarned on but I now must suffer because.
I will resort back to SQL Server 2012 for now
I do think there is validity to use a database for back testing uses.FACEBOOK ACCOUNT and TWITTER. Don't worry as I don't post stupid cat videos or what I eat!