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… Read More »Multiple CTE’s in a Single Query – Explanation
2022
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… Read More »New CTE Course Release!
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… Read More »Multiple CTE’s in a Query – Demo
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… Read More »Daily SQL Monitoring – SQL Server Versions for June
Using CTEs Instead of Derived Tables
Steve dives into using CTEs instead of derived tables. What the benefit of CTEs Do CTEs over derived tables benefit performance? And a quick demo… Read More »Using CTEs Instead of Derived Tables
SQL Server 2022 CTP Install Instructions
With the SQL Server 2022 coming sometime this year, Microsoft has recently released the Community Technology Preview version 2 (CTP2). In the past there have… Read More »SQL Server 2022 CTP Install Instructions
Course Coupons and Stedman Solutions Deals
Current Stedman Solutions SQL course coupon codes and on going deals you can only get from Stedman Solutions! 50% Off Our Newest Course! Coupon Code:… Read More »Course Coupons and Stedman Solutions Deals
CTE Syntax using WITH
What is with, WITH? If you don’t know watch Steve’s quick 2 minute video explanation. Transcription of video: Okay, so the syntax of using common… Read More »CTE Syntax using WITH
The Availability of Common Table Expressions
Steve quickly touches on which versions of SQL Server common table expressions are available on. Transcription of Video: So common table expressions have been available… Read More »The Availability of Common Table Expressions
Improve you query skills Steve’s CTE book!
Over 250 pages of Common Table Expression lessons! Download your FREE copy today! The Common Table Expression (CTE) is one of the more powerful and… Read More »Improve you query skills Steve’s CTE book!