Contest Archives - SQL Authority with Pinal Dave

This month's discount Comprehensive Database Performance Health Check Testimonials

Home

SQL SERVER – Making Recursive Parent-Child Queries Efficient

August 14, 2023

Pinal Dave

SQL Performance

Contest, 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

Contest, 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.