Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
We have old program that doesn't like the layout of 2014 MS SQL database layouts (and newly added statements or deprecated ones?). I have set the default databases that come with 2014 to 2012 compatibility mode. We'll give er another go. So when installing the program, it's going to create it's own new databases with tables etc. (audit database, etc)Are you saying it couldn't work on a newer MS SQL? I'd be a bit surprised if the product wouldn't run on 2016, assuming it just queries it's own database. It may not make use of new features. You might just have to put the particular database in a compatibility mode for SQL 2014 or 2012 or whatever.Maybe I misunderstand the question - what is "global compatibility mode" - you mean like for trying to run old programs on a newer OS? Isn't Server 2012 R2 a supported OS for SQL 2014 (I'm pretty sure it is from what I can find of 2014's system requirements)
Well, SQL does fairly well - but it will eat every bit of memory it can get, so wondered which. The memory use is by design though, cranks up as high as it can get and holds on to as much as the garbage collection will let it to keep query performance going - not that memory on its own is a solution to optimized queries and indexing....The thing using SQL is the bloated beast. SQL 2014 seems well designed and smooth running.