Blog Archives

Upcoming Speaking Engagements

There is a lot happening right now, so I thought I would put together a brief overview of upcoming speaking engagements. May 13th – When Corruption Strikes (PASS DBA Virtual Chapter Meeting) May 16th – Exploring SQL Server Join Types –

Posted in Classes, Corruption, CTE, SQL Saturday Tagged with: , , , , ,

Weekly SQL Training – MERGE Statement and Recursive Queries

The free SQL Server Queries weekly training is being presented by Emergency Reporting. The training is being presented by Aaron Buma and myself. This week we are covering two topics, first the MERGE statement will be covered by Aaron, then

Posted in Classes, CTE, Query Certification Tagged with: , , ,

Using a Common Table Expression Instead of a Derived Table

Here is a short video that shows how to convert those ugly derived table (SubQuery) queries into a common table expression to help clean up your TSQL code. This applies to Common Table Expressions on Microsoft SQL Server, and the

Posted in Classes, CTE Tagged with: , , , , , , ,

What is a Common Table Expression

I just a added a video to YouTube titled “What is a Common Table Expression”.  This video covers the extreme basics of what a CTE is on Microsoft SQL Server, and how to write that CTE in TSQL. Here is

Posted in CTE Tagged with: , , , , , , ,

SQL Query Training – Next Week – Set Operators, Derived Tables and CTEs

The SQL Training was a lot of fun this week we covered Top, Ranking, NTILE, and Analytic functions in preparation for the Microsoft 70-461 exam. Next week Aaron Buma and I will be presenting Set Operators, Derived Tables and CTEs. The live

Posted in 70-461 Training, Classes, CTE, SQL Server Tagged with: , , ,

Advanced CTEs Slides and Sample Queries

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

Posted in CTE, CTE Book, SQL Saturday Tagged with: , ,

Introduction to CTEs Slides and Sample Queries

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

Posted in CTE, CTE Book, SQL Saturday Tagged with: , , , , , , ,

Advanced CTEs Slides and Samples

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

Posted in CTE, CTE Book, SQL Saturday Tagged with:

In Denver for SQL Saturday

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

Posted in CTE, CTE Book, SQL Saturday Tagged with: , , ,

What is a Common Table Expression – Video

  Related Common Table Expression Links Sample Database for Common Table Expressions Writing Your First Common Table Expression with SQL Server Video: Writing Your First CTE with SQL Server Common Table Expressions – Terminating the Previous Statement CTE Scope Introduction

Posted in CTE, CTE Book Tagged with: , , , , , , ,

Newsletter Signup

Stay informed of Database Corruption Challenge events, and other things happening at with my newsletter.
Newsletter signup form.

Stedman Solutions


Common Table Expressions Book