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

Tom Pullen

Tom has been a DBA since 1998, he started out using SQL Server 4.2 and 6.5. He currently works for Helveta, a small company providing asset tracking software. He has previously worked for RM Education and Oxfam. He is a Senior DBA, with responsibility for system design, maintenance, database design, performance tuning, scalability and platform architecture. He has written several articles for sql-server-performance.com. He presented at SQL Bits 2, 4 and 6 (he only likes even numbers - so let's make SQL Bits 7 the exception that proves the rule!).

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