|
Black-belt T-SQL for developers with SQL Server 2005 and SQL Server 2008
Level:
Intermediate
Track:
n/a
Starts:
Apr 6 2008 9:00 AM
Ends:
Apr 6 2008 10:15 AM
Room:
EBC
Speaker:
Kevin Goff
A very code-intensive session - a solution in SQL Management Studio with over two-dozen T-SQL samples. This has been one of my most popular sessions.
This session will help database application developers get the most out of language enhancements in SQL Server 2005 and 2008. Here are some of the topics we’ll cover:
• Common Table Expressions and recursive queries (far beyond the common web example for an employee org chart)
• Table Types in SQL Server 2008 and how they provide efficient means for implementing flexible SQL queries
• The new MERGE statement in SQL Server 2008 to not only provide a single statement for INSERT/UPDATE/DELETE statements, but also provide automatic audit trail logging through the OUTPUT statement
• The new GROUP BY extensions in SQL Server 2008, to allow developers to incorporate multiple levels of subtotals into a single result set
• Miscellaneous samples for SQL Server 2005 enhancements, such as PIVOT, APPLY, RANK, and SNAPSHOT ISOLATION LEVEL
• Different techniques to avoid dynamic SQL
|