History of Microsoft SQL Server: Difference between revisions

Revision as of 11:49, 4 August 2017

Revision as of 12:32, 4 August 2017

Line 138:

[[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 re-write (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 pre-emptive multi-threading. SQL Server 7.0 also introduced a multi-dimensional database product called SQL OLAP Services.

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.

===SQL Server 2000===

SQL Server 2000 included more modifications and extensions to the Sybase code base, adding support for the [[IA-64]] architecture (now out of "mainstream" support<ref>http://www.computerworld.com/article/2516742/computer-hardware/microsoft-ending-support-for-itanium.html</ref>). By SQL Server 2005 the legacy Sybase code had been completely rewritten.<ref name="Scriptcase">{{cite web |url=http://www.scriptcase.net/blog/all-about-the-history-of-sql-server/ |title=All about the History of SQL Server |website=Scriptcase.net. |date=August 14, 2013 |accessdate=2016-08-15}}</ref>