Nested CTE’s in SQL Server
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 this video. Transcription of Video: So next, if you’ve got multiple CTE’s, we can do …
Month: June 2022
Row Constructor in SQL Server Demo and Explanation
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 row constructor. And this was added in SQL 2008. But it’s a way of saying …
Row Constructor in SQL Server Demo and Explanation Read more »
Free Copy of Steve Stedman’s CTE Book!
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 SQL Server. This book will show some of the more interesting things you can do …
DBA on Vacation
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 when someone goes on vacation. The view as the DBA: I have done everything that …
How to Write a Simple CTE Query
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 simple CTE query. So what I have is a test database here that I’ve set …
New SQL Update from Microsoft
Today Microsoft released a new update for SQL Server. SQL Server 2014 CU 4 + GDR (KB 5014164) 6/14/2022 Here are the latest updates for each version of SQL Server. SQL Server 2019 RTM CU 16 + GDRDownload links: CU …
Multiple CTE’s in a Single Query – Explanation
Check out this video explanation of how to put multiple CTE’s in a single query. Check back tomorrow for the demo on this. Transcription to this video: Now that we’ve covered how to build a CTE and how to replace …
New CTE Course Release!
One of the most overlooked features of SQL Server is the CTE which not only simplifies the query, but gives you the ability to do things that would otherwise be impossible (or at least very challenging) with SQL Server. Unleash …
Multiple CTE’s in a Query – Demo
As a continuation from the day before, here is the multiple CTE’s in a query demo. Transcription of the demo: All right. So here’s an example of a simple CTE that just does a union to return a list that …
Daily SQL Monitoring – SQL Server Versions for June
Here listed is the current percentages of SQL server versions running our Daily SQL monitoring service with Database Health Monitor. Compare this month’s percentages to Last Month’s Percentages What does this post mean?? We offer a service called SQL Daily Checkup. The …
Daily SQL Monitoring – SQL Server Versions for June Read more »