History of Microsoft SQL Server: Difference between revisions

Revision as of 23:39, 17 February 2023

Revision as of 09:34, 4 March 2023

Line 204:

===SQL Server 7.0===

[[File:Microsoft_SQL_Server_7.0_Setup_Splash_Screen.jpg|thumb|right|SQL Server 7.0 Splash Screen]]

SQL Server 7.0 was a major rewrite (using C++) of the older Sybase engine, which was coded in C. Data pages were enlarged from 2k bytes to 8k bytes. Extents thereby grew from 16k bytes to 64k bytes. User Mode Scheduling (UMS) was introduced to handle SQL Server threads better than Windows preemptive multi-threading, also adding support for fibers (lightweight threads, introduced in NT 4.0, which are used to avoid context switching<ref>{{cite web|url=https://technet.microsoft.com/en-us/library/aa175393%28v=sql.80%29.aspx|title=Developer tools, technical documentation and coding examples}}</ref>). SQL Server 7.0 also introduced a multi-dimensional database product called SQL OLAP Services (which became Analysis Services in SQL Server 2000).

SQL Server 7.0 would be the last version to run on the DEC Alpha platform. Although there were pre-release versions of SQL 2000 (as well as Windows 2000) compiled for Alpha, these were canceled and were never commercially released. Mainstream Supportsupport Endedended on December 31, 2005, asand Extendedextended Supportsupport Endedended on January 11, 2011.

===SQL Server 2000===