Common Table Expressions (CTEs) in SQL Server 2005 - Video Series Video Category: Transact-SQL Basics: Queries, Stored Procedures, Functions and more Skill Level: 300 (Intermediate) Versions/Editions Covered: SQL Server 2005 CTEs were added to SQL Server 2005 to simplify your recursive and heirarchical queries. This video series shows you the syntax and some common use of CTEs along with some "gotchas" of working with recursion

Videos in this Series:

Title Skill Length Download Part 1 - Common Table Expressions (CTEs) - What They Are and When to Use Them   300 12 mins. Download Part 2 - Common Table Expressions (CTEs) - Recursion and Recursive CTEs   300 14 mins. Download

< Return to list of all videos

Miscellaneous Bits & Pieces:

The command-line command "netstat" can show you active connections, TCP port usage, network statistics and more Keyboard Shortcut for Query Analyzer: CTRL+L shows the estimated execution plan SQL Server 2000 Resource Kit - More Helpful Tools: Simple Log Shipper is an ultra-simple set of log-shipping scripts. Very useful