SQL Server 2008 T-SQL Enhancements
Video References
These additional references will help you take what you've learned in this SQL Server Video to the next step.
Book References
SQL Server 2008 Transact-SQL Recipes A Problem-Solution Approach
Relevance: Pages 46-53 do a great job of covering GROUPING SETS and other Grouping enhancements. Likewise, page 71 covers Row Constructors, and other details covered in this video are also explained as well.
Links / References
SQL Server Books Online [link]
Relevance: The following links from Books Online will help provide additional information about the topics covered in this video:
Row Constructors (INSERT syntax)
Inline Variable Assignment (DECLARE syntax)
Compound Operators
Grouping Enhancements
MERGE
Table Valued Parameters
Microsoft Help and Support [link]
Relevance: Itzik Ben-Gan provides a great overview of new SQL Server 2008 Programability features - some of which coincide with the T-SQL enhancements covered in this video.
SQLMag.com [link]
Relevance: Itzik Ben-Gan addresses some of the details behind SQL Server 2008 T-SQL enhancements in two articles:
SQL Server 2008’s T-SQL Features
More SQL Server 2008 T-SQL Improvements
