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 …

SQL Saturday #265 in Portland Oregon Read more »

Its going to be a great day!   Ready for SQL Saturday 172 in Portland today, looking forward learning lots, and sharing my CTE Presentation with those who want to learn about Common Table Expressions. Please come to my CTE …

SQL Saturday #172 in Portland Oregon 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 …

Advanced CTEs Slides and Sample Queries Read more »

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 …

Introduction to CTEs Slides and Sample Queries Read more »

This month is going to be Common Table Expressions Month at SteveStedman.com.   My goal is to post one valuable post on a Common Table Expressions topic each day for the entire month. What is a Common Table Expression A …

Common Table Expression (CTE) Month at SteveStedman.com Read more »

Thanks to everyone who attended my CTE presentation at SQL Saturday in Portland Oregon today.   Have a great rest of the day.  As promised I have posted the slides and sample TSQL queries here.  If you have any questions, …

Unleashing Common Table Expressions in SQL Server – Slides and Sample Code Read more »