Sql Server 2008 – New Features

01Nov08

If you work with SQL Server on a regular basis, either writing custom queries, designing databases, or optimizing queries, this is a must see video as it covers a number of the enhancements to SQL Server 2008 including:

– 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 FileStream attribute that enables you to include files that are stored in the server file system, but can be managed by SQL Server
– New data types and support for Geodata and geometry
– New support for optimizing “empty” or row/column tables using the sparse keyword

Advertisements


No Responses Yet to “Sql Server 2008 – New Features”

  1. Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: