Web SQL Server Web Edition is a low- TCO option for Web hosting. It differs from Enterprise edition in that it supports fewer active instances (number of nodes in a cluster) and does not include some high-availability functions such as hot-add memory (allowing memory to be added while the server is still running), and parallel indexes. Standard SQL Server Standard edition includes the core database engine, along with the stand-alone services. It can manage databases as large as 524 petabytes and address 12 terabytes of memory and supports 640 logical processors (CPU cores). These editions are: Mainstream editions Enterprise SQL Server Enterprise Edition includes both the core database engine and add-on services, with a range of tools for creating and managing a SQL Server cluster.
Microsoft makes SQL Server available in multiple editions, with different feature sets and targeting different users. The current version is Microsoft SQL Server 2019, released November 4, 2019. Īs of July 2022, the following versions are supported by Microsoft:įrom SQL Server 2016 onward, the product is supported on 圆4 processors only and must have 1.4 GHz processor. SQL Server 2019, released in 2019, adds Big Data Clusters, enhancements to the "Intelligent Database", enhanced monitoring features, updated developer experience, and updates/enhancements for Linux based installations.SQL Server 2017, released in 2017, adds Linux support for these Linux platforms: Red Hat Enterprise Linux, SUSE Linux Enterprise Server, Ubuntu & Docker Engine.SQL Server 2012, released in 2012, adds columnar in-memory storage aka xVelocity.
Its name is entirely descriptive, it being server software that responds to queries in the SQL language. The history of Microsoft SQL Server begins with the first Microsoft SQL Server product-SQL Server 1.0, a 16-bit server for the OS/2 operating system in 1989-and extends to the current day. Main article: History of Microsoft SQL Server