With over 11 years of development into Database Health Monitor, there are many features there for many difference scenarios from performance to security, to overall server health. Months ago, I created the Database Health Monitor course to help people get the most value out of using the product, and with the purchase of that course you also get licensing for …
Stedman Solutions will be closed on the 4th of July to celebrate Independence Day. We wish everyone a safe and happy holiday. If you need emergency help during this time, you can reach us through the contact us form, or for existing customers just contact one of us by our cell phone or text. July 4th Fun Facts: July 4th …
This month brings treats for new Database Health Monitor users and old! Make sure you check back to see what’s released! This month we will announce a Sale on our Database Health Monitor Course When purchased it allow you to connect to 20 servers! New tips on how to use Database Health Monitor Hot key tips to make your job …
Transcription of Video: Let’s take a look at another recursive CTE. That’s not looking at tables, but it’s just looking at math. And here, we could create a recursive function that’s called sum of parts, and select from the sum of parts. Basically, we’re creating a function that selects from itself. And what it does is it says give me …
We hope you enjoyed last month’s Common Table Expressions theme and all the video tips and blog posts we released. July we will be focusing on Database Health Monitor and we will be releasing some SAVINGS as well as some TIPS AND TRICKS! So make sure to follow us on social media, sign up for our newsletter or check back …
Recursive CTE Examples Wed, 29 Jun 2022 Transcription of Video: One of the things I like play with is performance and pushing things to their limits. So what I want to do next is see how far can we push this sum of parts? Can we d Read more… Steve Explains how to build a Recursive CTE Tue, 28 Jun …
Transcription of Video: One of the things I like play with is performance and pushing things to their limits. So what I want to do next is see how far can we push this sum of parts? Can we do the sum of parts for 40,000? With the option of Max recursion equaling 40,000? No, we cannot do that because …
Transcription of Video: So here’s an example of building a recursive common table expression, I’m gonna start out with the with statement, we’re gonna call it department CTE. And we’re going to label the columns that we’re going to return department ID, the department, the parent, and those are all things we’ve seen before earlier in the presentation. And then …
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 with recursive CTE’s. Because with recursive CTE, we’re doing things that are really difficult to do any other way with SQL Server. So, a CTE is considered recursive when the CTE references itself. It’s interesting, …
Steve’s Introduction to Recursive Common Table Expressions Read more »
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 is the part that cannot reference the CTE itself, it has to start with some base starting point. So if you’re doing a hierarchy of departments, well, you’re starting the recursion may be giving me …