This is followed up a blog post of my earlier blog post on the same subject – Introduction to Hierarchical Query using a Recursive CTE – A Primer. In the article we discussed various basic terminology of the CTE. The article further covers following important concepts of common table expression. Let us learn in this video how to do Hierarchical Query using a Recursive CTE.
What is a Common Table Expression (CTE)
Building a Recursive CTE
Identify the Anchor and Recursive Query
Add the Anchor and Recursive query to a CTE
Add an expression to track hierarchical level
Add a self-referencing INNER JOIN statement
One of the very common question I receive on my facebook is that if there is any tutorial for SQL Server 2012 new enhanced features and solutions. I see this demand a bit increasing as the SQL Server 2012 is more and more being adopted. Here is the list of four tutorial which is specifically created for SQL Server 2012 by Microsoft.
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.
