What’s New in SQL Server 2008 T-SQL

2009

TL; DR

SQL Server 2008 has plenty of new, improved and updated features including extensions to Transact SQL. In this presentation Martin will talk about and demonstrate some of the new T-SQL features.

Session Details

SQL Server 2008 has plenty of new, improved and updated features including extensions to Transact SQL. In this presentation Martin will demonstrate some of the new T-SQL features including:

Row Constructors
Merge
Hierarchy Id Data Type
Sparse Column and Column Sets
Grouping Sets
Filestream Storage
User Defined Table Type
Table Valued Parameters
Date and Time Functionality
Dependency Reporting

3 things you'll get out of this session

Speaker

Martin Bell's previous sessions

What’s New in SQL Server 2008 T-SQL - 2009

Powershell - old tricks for a new dog? - 2009

"SELECT TOP(@x) Name FROM MyFavouriteDMVs ORDER BY MyRanking" - 2008

Identifying Performance Problems with SQL 2005 Profiler - 2007