Legacy application compatibility on SQL Server 2014 with in Memory computing
Posted on 2015-02-10
I would like some experts to comment on and give me some reference links on the following questions.
I know what In memory computing can do to transaction processing and querying in databases and I am looking forward to testing some applications on SQL Server 2014 - that has in memory computing ability.
Q 1 - Generally speaking - if a application that normally runs on SQL 2012 - would it need significant changes to run on SQL 2014 ( or any at all ).
Q2 - reated to Q1, I mean I am expecting regardless of in memory or not , applications could query/update SQL server 2014 data as it used to do on SQL 2012 ?
Q3 - I read somewhere that you can ( the DBA ) nominate some tables to run in memory - does this mean to get the benefit of in memory computing of SQL 2014 - does the DBA have to do the "tweaks" ?
Thanks and reference URLs would b great.