Transcription of Video: Now on to recursive common table expressions. This is my favorite part. And this is where it gets really fun is working… Read More »Steve’s Introduction to Recursive Common Table Expressions
Transcription of Video: Every recursive CTE needs an anchor query. And what an anchor query is, is it defines the start of the recursion. This… Read More »Recursive CTE Terminology
Transcription of Video: Now on to CTE’s in stored procedures, functions and views. When I first started doing this presentation several years ago, people would… Read More »CTE’s in Stored Procedures, Functions and Views
Transcription of Video: Here’s an example of a CTE that’s been created for data paging, where the select statement inside of the CTE that shown… Read More »Steve Demonstrates Data Paging with CTE’s
Video transcription: Basically, what data Paging is, is when you’ve got a large large result set and what you want to do is display like… Read More »Steve explains data paging with CTE’s
If you have multiple CTE’s in a query then you can do what’s called a nested CTE. This is what Steve will go over in… Read More »Nested CTE’s in SQL Server
Added to SQL Server in 2008 Steve explains and demonstrates how to set up row constructor. Transcription of video: So there’s this thing called a… Read More »Row Constructor in SQL Server Demo and Explanation
Improve you query skills with Common Table Expressions. The Common Table Expression (CTE) is one of the more powerful and often overlooked features in Microsoft… Read More »Free Copy of Steve Stedman’s CTE Book!
There are 2 perspectives here to the DBA on vacation, typically in an organization with only a single DBA so there is no cross coverage… Read More »DBA on Vacation
Let’s start slow with a simple CTE query demo for easy absorption. Transcription of video: So let’s take a look at how to write a… Read More »How to Write a Simple CTE Query