Question

Compare SQL servers from 2000 till now 2020, make sure to include minimum requirements.

Answer 1

SQL Server 2000:
SQL Server 2000 included more modifications and enhancements to the Sybase codebase, adding support for the IA-64 architecture (which is currently not supported by "mainstream" ). By SQL Server 2005, the old Sybase code was completely rewritten.

Since the release of SQL Server 2000, progress has been made in performance, IDE client tools, and several additional systems included in the SQL Server 2005 package. These include:

1. Extract-Transform-Load (ETL) Tool (SQL Server Integration Services or SSIS)
2. SQL Server Reporting Services (SSRS) or Report Server
3. OLAP and Data Mining Server (Analysis Services)
4. several messaging technologies, notably Service Broker and Notification Services.

MINIMUM REQUIREMENTS: SQL Server 2000 will run on Windows 98, Windows NT Server 4.0 Service Pack 5 or later, Windows NT Workstation 4.0 Service Pack 5 or later, and Windows 2000 (all editions). SQL Server 2000 also requires Internet Explorer 5.0 or later as Microsoft Management Console and HTML Help require it.

SQL Server 2005 :

SQK Server 2005(formerly codenamed "Yukon") was released in November 2005. It included built-in support for manipulating XML data in addition to relational data. For this purpose, he defined the xml datatype, which can be used either as datatype in database columns or literals in queries. XML columns can be linked to XSD schemas; The stored XML data is validated against the schema. XML is converted to an internal binary data type before being stored in the database. Specialized indexing methods are now available for XML data. XML data is queried using XQuery; SQL Server 2005 has added some extensions to the T-SQL language to embed XQuery in T-SQL.

MINIMUM REQUIREMENTS: Requirements for the 32-bit version of SQL Server 2005 Enterprise Edition
Processor with a clock speed of 500 MHz or higher. 512 MB of RAM. 42 MB hard disk space, up to approximately 735 MB hard disk space.

SQL Server 2008:
SQL Server 2008 (formerly codenamed "Katmai") ​​ was released on August 6, 2008, as announced to the SQL Server Interest Group at the ESRI 2008 User Conference on August 6, 2008. Ed Katibah (Manager spatial programs) at Microsoft), and strives to make data management self-tuning, self-organizing, and self-sustaining with the advancement of SQL Server Always On technologies to achieve virtually zero downtime. SQL Server 2008 also includes support for structured and semi-structured data, including digital media formats for images, audio, video, and other multimedia data.

MINIMUM REQUIREMENTS: Pentium III-compatible processor or faster. 1GHz minimum. Recommended 2GHz or faster. 512MB minimum, 2GB or more recommended. Report Server will use a maximum of 3GB.

SQL Server 2008 R2:
SQL Server 2008 R2 (10.50.1600.1, formerly codenamed "Kilimanjaro") was announced at TechEd 2009 and released into production on April 21, 2010. SQL Server 2008 R2 adds specific features to SQL Server 2008, including a core management system data called Master Data Services, centralized management of entities and master data hierarchies. Also Multi Server Management, a centralized console for managing multiple SQL Server 2008 instances and services, including relational databases, reporting services, analytics services, and integration services.

MINIMUM REQUIREMENTS: For 32-bit systems, an Intel or compatible processor with a clock speed of 1 GHz or higher (2 GHz or higher recommended) is used. For 64-bit systems, 1.4 GHz processor or higher. 512 MB RAM (2 GB or more recommended) 2.2 GB hard disk space May 26, 2010
Maximum used memory: 1 GB Maximum database size: 10 GB

SQL Server 2012:

At the 2011 Professional Association for SQL Server (PASS) Summit on October 11, Microsoft announced that the next major version of SQL Server (codenamed "Denali") would be SQL Server 2012. It was released on March 6, 2012. SQL Server 2012 Service Pack 1 was released into production on November 9, 2012, and Service Pack 2 was released into production on June 10, 2014.It has been announced that this is the latest version to natively support OLE DB and instead prefers ODBC for native connectivity.

MINIMUM REQUIREMENTS:

• 32-bit systems.
• Computer with an Intel or compatible processor with a clock speed of 1 GHz or higher (2 GHz or higher recommended).
• 64-bit systems.
• Processor with a clock speed of 1.4 GHz or higher.
• Minimum 512 MB of RAM (2 GB or more recommended).
• 2.2 GB of free hard disk space.

SQL Server 2014:
SQL Server 2014 was released into production on March 18, 2014 and released to the general public on April 1, 2014, with the build number at the time of release 12.0.2000.8. Until November 2013, there were two editions of OSAGO: OSAGO1 and OSAGO2. SQL Server 2014 provides a new in-memory storage capability for tables that can fit entirely in memory (also known as Hekaton). While small tables can be completely memory-resident in all versions of SQL Server, they can also reside on disk, so the work involves reserving RAM, writing deleted pages to disk, loading new pages from disk, locking pages in RAM while they are performing operations and many other tasks. By treating a table as guaranteed to be completely memory resident, many "internal" disk databases can be avoided.

MINIMUM REQUIREMENTS:

• Minimum operating system. Microsoft Windows (32 bit), Microsoft Windows (64 bit)
• Processor type. Athlon 64, Opteron, Pentium 4, Pentium III, Xeon.
• Processor speed. 1 Hz, 1.4 Hz.
• Minimum RAM size. 1 GB.
• Min. Free hard disk space. 6 GB.

SQL Server 2016:
The official public release date for SQL Server 2016 is June 1, 2016. The RTM version is 13.0.1601.5. Service Pack 2 updates the version to 13.2.5026. SQL Server 2016 is only supported on x64 processors. It is no longer supported on x86 processors.

MINIMUM REQUIREMENTS:

• 6 GB of disk space in NTFS file format.
• . NET Framework 4.6 or later.
• 1 GB memory.
• 64-bit processor with a clock speed of 2.0 GHz or higher.
• Compatible Windows Server OS.

SQL Server 2017
On October 2, 2017, Microsoft launched SQL Server 2017 along with Linux support.

MINIMUM REQUIREMENTS:

For Microsoft SQL Server 2017, there should be a minimum of 32 GB and increase by 2 GB per user, over 10 users. Installing SQL Server 2017 requires only 6 GB of available hard disk space. Keep in mind that there should also be enough space for the database and for future expansion.

SQL Server 2019:
Microsoft launched SQL Server 2019 on November 4, 2019. SQL Server 2019 (15.x) introduces Big Data Clusters for SQL Server. It also provides additional features and enhancements for SQL Server Database Engine, SQL Server Analysis Services, SQL Server Machine Learning Services, SQL Server on Linux, and SQL Server Master Data Services.

MINIMUM REQUIREMENTS:

SQL Server 2019 requires a minimum of 6 GB of available hard disk space.

Disk space requirements depend on the SQL Server components being installed. For more information, see the section Hard disk space requirements later in this article. For information on the supported storage types for data files, see Storage types for data files.

Minimum:

• Express Editions: 512 MB
• All other editions: 1 GB

If you are satisfied by my answer please give a thumbs up. Thank you.