SQL Server 2008 New Features

This series will be an introduction and demonstration of the new features of SQL Server 2008.


Total Time: 1 Hour 4 Minutes              Total Videos: 6

  • Video List

    • Video 1: Row Constructors
      (Running Time: 5:08)

      In this video, you will learn how to use Row Constructors, which is a new T-SQL enhancement included with SQL Server 2008. Row Constructors allow you to enter multiple records into a table using a single INSERT Statement.


    • Video 2: Merge Statement
      (Running Time: 16:21)

      This MERGE statment allows you to INSERT, UPDATE, or DELETE records on one table, based on the results of a join with another table. This video will show you how to take advantage of this new T-SQL command and walk you through a detailed example to demonstrate its use.


    • Video 3: Grouping Sets
      (Running Time: 7:36)

      This video will demonstrate how to use Grouping Sets, which is another T-SQL enhancement that will be introduce with SQL Server 2008. This feature adds more functionality to the existing GROUP BY clause and lets you perform grouping on multiple groups within the same SQL Statement.


    • Video 4: Date and Time Data Types
      (Running Time: 6:38)

      SQL Server 2008 includes four new data types to work with date and time data! This video will walk you through examples of how to use the DATE, TIME, DATETIME2 and DATETIMEOFFSET data types that will be introduced.


    • Video 5: HierarchyID Data Type
      (Running Time: 21:13)

      This video will demonstrate how to use the new HierarchyID Data Type introduced with SQL Server 2008. This new data type is a System Data Type used for hierarchical data.


    • Video 6: Table-Valued Parameters
      (Running Time: 7:41)

      This video will provide an introduction to User-Defined Tables and Table-Valued Parameters which will be included with SQL Server 2008. You will see how to use this new functionality to send multiple rows of data into a stored procedure!