Blog Archives

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: , , , , , , ,

Next Week’s Free SQL Training: MERGE Statement and Recursive Queries

Next week, on Thursday Feb 26th Aaron Buma and I, as part of the Free SQL Training provided by Emergency Reporting, will be presenting on the use of the MERGE Statement and how to do Recursive Queries. This is intended

Posted in Classes, Query Certification 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: , , , , , , ,

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: , , , , , , ,

SQL Saturday #265 in Portland Oregon

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

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

A great day at PASS Summit today.

I started out the day with the keynote presentation with some great info on PASS and the PASS volunteers, followed by Microsoft presenting  on in memory tables, and native compilation for stored procedures, described and demonstrated as “Wicked Fast”. Next

Posted in Summit 13 Tagged with: , , , , , ,

CTE book signing at PASS SUMMIT 2013

A great turnout for the CTE book signing tonight.  Enjoy the books.

Posted in Summit 13 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: , , ,

I’m Speaking at SQL Saturday #190 in Denver

  One of my sessions was accepted for SQL Saturday #190 in Denver this year. Please come see my CTE presentation. Common Table Expressions – Introduction Have you ever wanted to create a recursive query, but didn’t see how to

Posted in 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 SteveStedman.com with my newsletter.
Newsletter signup form.

Stedman Solutions

StedmanSolutionsRemoteSkilledDBA

Common Table Expressions Book

Paperback:

Kindle: