Comparison of several scenarios for high availability in SQL Server 2012, where AlwaysOn advantage is compared to several scenarios for SQL Server 2012 high availability and disaster recovery, replication, clustering, mirroring, what are the advantages of new technology AlwaysOn, This article will make a rough comparison of the table format. SQL Server 2014 creates a memory-optimized database that uses a memory-optimized data filegroup to create a database, unlike a normal database, to add files to a filegroup, file type FILESTREAM data for SQL Server 2014 to create a memory-optimized table for SQL Server In-memory OLTP helps improve the performance of OLTP applications with efficient memory-optimized data access, native compilation of business logic, and lock and latch release algorithms. SQL Server 2014 installation Deployment AlwaysOn, principle, high availability mode the installation deployment between SQL Server 2012/2014 is very different, because my current environment has been switched to SQL Server 2014 version, The use of 2012 and 2014 is not very small. You are welcome to discuss my number: 17660121.
Share SQL Server 2012/2014 in-memory databases, AlwaysOn, reference materials and online summaries
