TSQL JOIN Types Poster (version 4.1)

After someone reported a small bug in the “two INNER JOINs” diagram, I have created an update to the poster. This is update 4.1, only a minor version upgrade due to only a small change. The thing I love about

Posted in Uncategorized Tagged with: , , , , , , ,

TSQL JOIN Types Poster (Version 4)

So many times I have been asked for help with a query, where the question really comes down to the understanding of the difference between INNER and LEFT or RIGHT JOINs. I created this poster a few years ago and

Posted in TSQL Tagged with: , , , , , , ,

Multiple CTEs in a Query

Day 10 of Common Table Expression Month (June) at SteveStedman.com, today we will be taking a look at how to use multiple CTEs in a query. These queries will be using that database that was set up in a previous posting

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

A Fun Thanksgiving Day Query.

Download the Thanksgiving query sample code here. I thought it would be fun to put together a query to get us in the spirit of Thanksgiving dinner tonight. This query is using techniques from another recent posting on CSV formatting query

Posted in TSQL Tagged with: , , ,

Restoring A Log Chain

This is a followup to my Whats more important than a backup plan article posted a couple of months ago. When you do a database restore, including log backups, it is very important to get the log chain in the

Posted in Recovery Tagged with: , , , , , , ,