It was quite clearly a rousing success, well attended, and sure to be talked about long after Common Table Expressions become the subject of vintage technology jokes and bad career choices.
As promised at the presentation, I have posted here for download a .zip file of resources used in my presentation, including:
- The PowerPoint (2007) Presentation
- All SQL code demonstrated
- My Notes (Word 2007)
- Using Common Table Expressions (MSDN)
- Common Table Expressions and Performance (Pragmatic TSQL Programmer)
- Using MAXRECURSION with recursive queries (Pinal Dave)
- Recursive Queries using Common Table Expressions (CTE) in SQL Server (MSSQL Tips)
- Ranking Common Table Expressions (Database Server)
- SQL Server 2008 AdventureWorks sample databases (CodePlex)
…and if you made it to the presentation, thanks!