I’ve been selected to speak at the Tampa SQL Saturday coming up at the end of January. I’m a bit pumped to be going down there since I woke up this morning to below zero weather for yet another day. Not that I’m complaining, but my feet could definitely use a little bit of heat. I know it’s a bit chilly down there right now, I heard it was 37 degrees. But let me tell you… that would be awesome right about now.
Here is the topic that I’ll be speaking on:
ABCs of CTEs
Common Table Expressions (CTE) aren’t as common as their name implies. CTEs are often seen as a secret part of the dark art of recursion. This session will explore CTEs to show how they can be extremely useful in improving performance and legibility of T-SQL code. And, of course, we will look at their use in returning recursive data.
- Understand of basic T-SQL coding
- Provide an understanding of the purpose and use of CTEs for recursion and derived tables
- Define the pro’s and con’s to using CTEs in recursion and for derived tables
- Demonstrate real-world examples detailing methods for using CTEs to solve coding challenges
Hopefully if you are in the area, you’ll stop by and listen. If you want to, feel free to make fun of my lack of sun from the long, cold Minnesota winter. And now that I’ve purchase flight, hotel, and the rental… I’ll be there for certain.