Microsoft has released a new version of its popular Database management system (SQL Server). It is Microsoft SQL Server 2008. So what are the benefits of SQL SERVER 2008 for Developers & Programmers.
SQL Management Studio improvements including IntelliSense.
New Data Types for just dates or times (no more storing time when you only need the date).
New Hierarchical data support .IsDescendent(), that can automatically pull a hierarchical view of data (no more custom recursive queries).
New Grouping Sets statement which enables you to automatically group dimensions in a query for easy aggregation and reporting.
New Merge statement which provides automatic insert/update semantics for keeping multiple data sources in sync.
New data types and support for Geodata and geometry.
New support for optimizing "empty" or row/column tables using the sparse keyword.
New FileStream attribute that enables you to include files that are stored in the server file system, but can be managed by SQL Server.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment