What are the new features available in MSSQL 2005?
Print this Article
Comment on this Article
Last Updated:
March 29, 2007 1:58 PM
MSSQL 2005 offers many new features, including:
- Native XML Support - Native XML data can be stored, queried, and indexed in a SQL Server database—allowing developers to build new classes of connected applications around Web services and across any platform or device.
- ADO.NET Version 2.0 - From new support for SQL Types to Multiple Active Result Sets (MARS), ADO.NET in SQL Server 2005 evolves dataset access and manipulation to achieve greater scalability and flexibility.
- Security Enhancements - The security model in SQL Server 2005 separate users from objects, provides fine-grain access, and enables greater control of data access. Additionally, all system tables are implemented as views, providing more control over database system objects.
- Transact-SQL Enhancements - SQL Server 2005 provides new language capabilities for developing scalable database applications. These enhancements include error handling, recursive query capabilities, relational operator PIVOT, APPLY, ROW_NUMBER and other row ranking functions, and more.
- Full-Text Search Enhancements - SQL Server 2005 supports rich, full-text search applications. Cataloging capabilities provide greater flexibility over what is cataloged. Query performance and scalability have been improved dramatically, and new management tools provide greater insight into the full-text implementation.
For more information on the new features in MSSQL 2005 see the Top 30 Features of SQL Server 2005 on the Microsoft SQL Web site.