Content deleted Content added
Citation bot (talk | contribs) Add: date, title. Changed bare reference to CS1/2. | Use this bot. Report bugs. | Suggested by BrownHairedGirl | #UCB_webform 342/902 |
Citation bot (talk | contribs) Add: title. Changed bare reference to CS1/2. | Use this bot. Report bugs. | Suggested by BrownHairedGirl | #UCB_webform 227/3545 |
||
Line 206:
* several messaging technologies, specifically Service Broker and Notification Services
SQL Server 2000 also introduced many T-SQL language enhancements, such as table variables, user-defined functions, indexed views, INSTEAD OF triggers, cascading referential constraints and some basic XML support.<ref>{{cite web | url=http://www.informit.com/articles/article.aspx?p=25735 | title=What's New in SQL Server 2000 | New SQL Server 2000 Features | InformIT }}</ref><ref>{{cite web | url=http://sqlmag.com/t-sql/sql-server-2000s-coolest-features | title=ITPro Today: IT News, How-Tos, Trends, Case Studies, Career Tips, More }}</ref>
With the release of Service Pack 3, Microsoft also released the first 64-bit version of the SQL Server for the [[Itanium]] IA-64 platform. (not to be confused with the [[x86-64]] platform) Only the SQL Server relational engine and SQL Agent were ported to Itanium at this time. Client tools, such as Enterprise Manager, would still need to be run from 32-bit x86 clients. The first release of SQL IA-64 was version 8.00.760, with a build date of February 6, 2003.
Line 252:
The first SQL Server 2008 R2 service pack (10.50.2500, Service Pack 1) was released on July 11, 2011.<ref name="SQL Server® 2008 R2 SP1">{{ cite web | url = http://www.microsoft.com/download/en/details.aspx?id=26727 | title = Microsoft® SQL Server® 2008 R2 SP1 | website = [[Microsoft]] | accessdate = 2011-09-19 }}</ref> The second SQL Server 2008 R2 service pack (10.50.4000, Service Pack 2) was released on July 26, 2012.<ref name="SQL Server® 2008 R2 SP2">{{ cite web | url = http://www.microsoft.com/en-us/download/details.aspx?id=30437 | title = Microsoft® SQL Server® 2008 R2 SP2 | website = [[Microsoft]] | accessdate = 2012-07-31 }}</ref> The final SQL Server 2008 R2 service pack (10.50.6000, Service Pack 3) was released on September 26, 2014.<ref name="SQL Server 2008 R2 Service Pack 3">{{ cite web | url = http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/09/26/sql-server-2008-r2-service-pack-3-has-released.aspx | website = SQL Release Services Blog | title = SQL Server 2008 R2 Service Pack 3 has released | accessdate = 2014-10-01 }}</ref>
SQL 2008 R2 would be the last version of SQL Server to run on the [[Itanium]] (IA-64) platform. However, the x64 platform would continue on in force. Extended support for SQL Server on Itanium would continue until 2018. <ref>{{cite web | url=https://rcpmag.com/articles/2010/04/05/microsoft-dropping-itanium-support.aspx | title=Microsoft Dropping Itanium Support - }}</ref>
=== SQL Server 2012 ===
| |||