CTE Hierarchy compared to the alternative
After my CTE presentation a while back I was asked many questions, and received several great suggestions from people. One question was how does… Read More »CTE Hierarchy compared to the alternative
CTE
Using a CTE to Split a String Into Rows with Line Numbers
Years ago while working on my CTE presentation for a SQL Saturday I added a blog post called “Using a CTE to Split a String… Read More »Using a CTE to Split a String Into Rows with Line Numbers
SQL Server Memory Hog Query
The article could be named, “How to use up all of your SQL Server available memory with a single CTE query.” Another name for the… Read More »SQL Server Memory Hog Query
CTE Query Performance
The following question came up when working on my CTE presentation for SQL Saturday. Does a query that JOINs a CTE to itself execute the… Read More »CTE Query Performance
Multiple CTE’s in a single Query
Common Table Expressions are a great way to simplify complex derived table queries. If it makes sense to break out one derived table or subquery… Read More »Multiple CTE’s in a single Query
Common Expression Tables – Introduction
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… Read More »Common Expression Tables – Introduction
Data Paging with CTEs
The following is chapter 7 from my Common Table Expressions book in its entirety. I can remember the first time that I worked on data paging code. I… Read More »Data Paging with CTEs
Multiple CTEs in a Query
The following is chapter 6 from my Common Table Expressions book in its entirety. READER NOTE: Please run the CTEBookSetup.sql script in order to follow along with the examples in… Read More »Multiple CTEs in a Query
Hierarchical Queries
Creating a SQL Server hierarchical query can be incredibly useful, but also very difficult without the right tools. The following is chapter 5 from my Common… Read More »Hierarchical Queries
CTE Book Sample Code
As part of the CTE book there is a sample database that all the queries use. You can download the create script for that sample… Read More »CTE Book Sample Code