Common Table Expressions (CTEs) in SQL Server 2005 - Video Series Video Category: T-SQL Basics: Queries, Datatypes, Collations and Unicode, 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:

SQLDIAG.EXE is a handy tool that ships with your SQL Server that can provide you with detailed information about your SQL Server and its environment. Simply run SQLDIAG.EXE from the command-line Keyboard Shortcut for SQL Server Management Studio: CTRL+SHIFT+U converts text to uppercase Many people get confused about licensing for their SQL Server when their SQL Server is used for the company website. Bottom line: buying one license for your SQL Server because the web server is only one user is not sufficient. Microsoft requires that each connection that takes advantage of the data from your SQL Server be licensed.