The following is chapter 2 in its entirety from my Common Table Expressions book. What is a Common Table Expression? The first time I tried snowboarding after being a skier for many years it was very uncomfortable. Everything was difficult, riding the snowboard was strange and I ended up with my face in the snow more times than I can …
The following has been republished from my Common Table Expressions book. Chapter 1. Memory Tables There was a 1996 Michael Keaton movie called Multiplicity where he duplicates himself to get more work done. It first started out that he just needed help to finish up his work and be able to attend his child’s ballgame. The theme of the movie …
Back in 2012 when I was writing my Common Table Expressions book, I came up with the following CTE in a function to split a string into rows. Original Post: http://stevestedman.com/2012/04/using-a-cte-to-split-a-string-into-rows/ At the time, I thought it was pretty handy function, I ended up including it as an example in my CTE book, and I have used it dozens of …
On Wednesday June 24th at 6:00pm pacific time or( 25 Jun 2015 01:00 GMT ) will be speaking at the 24HOP (24 Hours of Pass) conference which is broadcast online. I will be presenting on Advanced Common Table Expressions, and it is going to be fun. Here is the session abstract. You have been introduced to Common Table Expression, you understand …
Advanced Common Table Expressions – 24 Hours of PASS Read more »
My second presentation at SQL Saturday in Portland Oregon is Advanced Common Table Expressions. Here is the outline for the session. 1. Hierarchical Recursive CTEs 2. Manipulating Data 3. Common Use Cases 4. CTE Performance Considerations Download the presentation and samples here: Advanced CTEs.zip See Also: Introduction to CTEs presentation
Today I am at SQL Saturday Portland Oregon, and at 9:00am I am presenting the Introduction To Common Table Expressions session: Here is the abstract: Have you ever wanted to create a recursive query, but didn’t see how to do it. With the Common Table Expressions session you will learn everything needed to start using CTE’s for recursive queries, as …
I will be attending SQL Saturday #265 in Portland Oregon on November 16th 2013. This will be my second time attending SQL Saturday in Portland, and it is looking to be a great event. There are some great speakers on the line up that I am looking forward to learning from. I will be presenting 2 sessions on Common Table …
Wednesday at 6:45PM I will be doing a book signing of my Common Table Expressions Book. Joes2Pros will be giving away 30 books during this signing. Come by the Joes2Pros booth for a chance at one of the 30 CTE Books. Please come by and visit! See You There!
Today I presented on Advanced CTEs at SQL Saturday Denver. Here are my slides and sample code for download: Advanced CTEs Denver Thanks to everyone who attended, I hope you enjoyed the presentation. Don’t forget to try out the Database Health Reports. Here is what some people are saying about it: Raving Fans
I will be speaking at SQL Saturday Denver, presenting on Advanced Common Table Expressions. This presentation should be a lot of fun. I will be covering all the advanced and fun CTE features that I haven’t had time to fit into my introduction to CTE session in the past. Here is the outline of the session: 1.Recursive CTEs. 2.Hierarchical CTEs. …