Come see how to build efficient common table expressions (CTE) by hand and how they are used to improve your development options in SQL Server. Along the way we will compare CTEs to Table parameters and also see how to use them with finding duplicates, segmenting data, ranking, dynamic crosstab, and recursion. This session is not for the weak!