Challenge Archives - SQL Authority with Pinal Dave

Apr 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Making Recursive Parent-Child Queries Efficient

August 14, 2023

Pinal Dave

SQL Performance

Challenge, Recursive, SQL Joins

One puzzle is finding out how many employees each manager is responsible for in a company. Let us Make Recursive Parent-Child Queries Efficient.

SQL SERVER Challenge – Cumulative Total Calculation

June 16, 2023

Pinal Dave

SQL Interview Questions and Answers

Challenge, CTE, Ranking Functions, SQL Scripts, SQL Sub Query

Today we will see a very interesting SQL SERVER Challenge about Cumulative Total Calculation. During a recent Comprehensive Database Performance Health Check.