Content deleted Content added
→Processor support: MSFT kills off ARM support for SQL Server |
→SQL Server 7.0: Becomes Oracle's top competitor |
||
Line 206:
===SQL Server 7.0===
[[File:Microsoft_SQL_Server_7.0_Setup_Splash_Screen.jpg|thumb|right|SQL Server 7.0 Splash Screen]]
After problems at its main rivals, SQL Server became Oracle's most important competitor.<ref name="rdbmslateryears20070612">{{Cite interview |interviewer=Burton Grad |title=RDBMS Plenary Session: The Later Years |url=https://archive.computerhistory.org/resources/access/text/2013/05/102701921-05-01-acc.pdf |access-date=2025-05-30 |publisher=Computer History Museum |date=2007-06-12}}</ref> 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 support ended on December 31, 2005, and extended support ended on January 11, 2011.
| |||