Sql server sp2 version windows#

In-Memory OLTP is installed with the SQL Server 2014 Engine without requiring any additional actions and allows in-memory performance benefits without rewriting your database application or refreshing your hardware. Provides in-memory OLTP capabilities built into core SQL Server database to significantly improve the transactional speed and throughput of your database application.

Sql server sp2 version windows#

In addition, Microsoft SQL Server 2014 also provides new hybrid solutions for cloud backup and disaster recovery as well as takes advantage of new capabilities in Windows Server 2012 R2 to provide enterprise-class availability and scalability with predictable performance and reduced infrastructure costs.

Microsoft SQL Server 2014 uses a common set of tools to deploy and manage databases both on-premises and in the cloud, which makes it easier for customers to take advantage of the cloud with existing skills.

Microsoft SQL Server 2014 enables customers to build mission-critical applications and Big Data solutions using high-performance, in-memory technology across OLTP, data warehousing, business intelligence and analytics workloads without having to buy expensive add-ons or high-end appliances. It uses in-memory technologies, faster insights from any data to any user in such familiar tools like Excel, and a resilient platform for building, deploying, and managing solutions that span on-premises and cloud. Microsoft SQL Server 2014 is foundation of MicrosoftвЂ™s comprehensive data platform delivering avant-garde performance for mission-critical applications.