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 the possibilities using Common Table Expressions! Learn how in our our new course! As an introductory special, get this course …
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 says John, Mary, and Bill. And then we have a second one, that’s last names that just returns, Smith give …
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 pie chart above represents all of our current customers using this service and what SQL Server versions they are running. …
Daily SQL Monitoring – SQL Server Versions for June Read more »
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 explanation Transcription of video: Now let’s take a look at some more complex examples of how to use a CTE instead of a derived table. Now use a CTE instead of a derived table, it’s …
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 usually been between 2 to 4 CTPs before a version of SQL Server is released. Here is a short video showing the 2022 installer. A couple of small differences with the install, but not far …
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: FEB-RELEASE50 Using our instruction and scripts included in this course you will successfully configure email notifications when blocking occurs. Address blocking BEFORE it takes down your system. See All Our Online Courses! On Going Deals …
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 table expressions is to use the WITH keyword. all CTE start with the word WITH rather than select like you would normally have in your queries. And it can be confusing if you’re assuming that …
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 since SQL Server 2005. And I really wish that I’d learned about common table expressions when they first came out. I think it was around 2010 2011 that I first learned about them. And I …
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 often overlooked features in Microsoft SQL Server. This book will show some of the more interesting things you can do with a CTE. You will learn how CTEs are a great alternative to derived table …
In this short but to the point video Steve explains the question “what is a CTE?” Transcription of this video: CTE is kind of this concept of what we’re calling a virtual table where it’s like a sub query or like a view where it’s referencing another chunk of SQL query that’s going to be used and named. Similar to …