SQL Server 2008 TSQL Enhancements

A look at the new TSQL features of SQL Server 2008, including - MERGE - Table-valued Parameters - Grouping Sets - Row Constructors - Hints

Speaker focus

Tom Pullen

Tom has been a DBA since 1998, he started out using SQL Server 4.2 and 6.5. He works for RM Education, a provider of hardware, software and hosting services to the education sector in the UK and abroad. Before that he worked for Oxfam. He is a senior DBA, with responsibilities for system design, installation, maintenance, troubleshooting He has written several articles for sql-server-performance.com. He presented at SQL Bits 2 and 4.

Tom Pullen's blog http://thomaspullen.spaces.live.com/blog/

---

Downloads

File Type Ext ContentName Zip File .zip Slide Deck & Scripts

<< 1 >>

---

Other sessions from this conference

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

2005 SQLCMD Scripting

Administering SQL Server 2008 and 2005 with Windows PowerShell

Development Life Cycle using Visual Studio Team Edition for DB Professionals

Extending SSIS with custom Data Flow components

Getting to grips with Service Broker.

I/O! I/O! It’s off to disk we go...

Introduction to SQL 2008 Performance Data Collector

Making more of SSIS in 2008

Making the leap into Advanced SQL

Master Data Management (MDM)

New Product Demos

Recruitment Open Panel

Reporting in SQL Server 2008

SQL Server 2008 – Declarative Management Framework concepts & database problem solutions with policy management.

SQL Server High Availability and Disaster Recovery Overview

Transient data in SQL Server

Understanding LINQ in .NET Framework V3.5 and Beyond

Using Analysis Services as a data source for Reporting Services reports

What Are You Waiting For?

Where do you live? Intro to spatial indexing