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… Read More »Free Copy of Steve Stedman’s CTE Book!
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… Read More »DBA on Vacation
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… Read More »How to Write a Simple CTE Query
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… Read More »New SQL Update from Microsoft
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
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!
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
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
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
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