Database Health Monitor Bundle
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… Read More »Database Health Monitor Bundle
Happy 4th of July
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… Read More »Happy 4th of July
Database Health Month!
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… Read More »Database Health Month!
Looking at Math with Recursive CTE’s
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… Read More »Looking at Math with Recursive CTE’s
What’s Coming in July?
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… Read More »What’s Coming in July?
June Blog Post Wrap-up
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… Read More »June Blog Post Wrap-up
Recursive CTE Examples
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… Read More »Recursive CTE Examples
Steve Explains how to build a Recursive CTE
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… Read More »Steve Explains how to build a Recursive CTE
Steve’s Introduction to Recursive Common Table Expressions
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
Recursive CTE Terminology
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