This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
The Halloween server shadow puzzle shows three cabinets and their shadows; one cable shape does not match.

The Halloween Server Shadow: Spot the Impossible One

October 25, 2026
Pinal Dave
SQL Puzzle

The Halloween server shadow puzzle hides one mismatched cable. Look at three racks and choose the shadow that cannot belong.

Read More
Deadlock or just a queue diagram: sessions A, B and C and resources X and Y, connected by hold and wait arrows.

Deadlock or Just a Queue? Sunday SQL Puzzle

October 18, 2026
Pinal Dave
SQL Puzzle

Deadlock or just a queue? Follow three sessions and find the cycle in this Sunday SQL puzzle.

Read More
Four thick, differently coloured cables run from A through D on the left. Only one cable reaches the database on the right.

Which Cable Reaches the Database? A Sunday Puzzle

October 11, 2026
Pinal Dave
SQL Puzzle

Which cable reaches the database? Four coloured cables cross behind a rack. Follow each one to its destination.

Read More
The backup that disappeared puzzle shows before and after shelves of six labeled cards, with one question-mark gap.

The Backup That Disappeared: Sunday Puzzle

October 4, 2026
Pinal Dave
SQL Puzzle

The backup that disappeared is one of six cards. Compare the shelves and name the missing card after another card moves.

Read More
Two dark horizontal lines at different positions in a perspective server aisle. Compare their lengths before reading the answer.

The Longer Query: A Sunday SQL Illusion

September 27, 2026
Pinal Dave
SQL Puzzle

The longer query seems obvious in this Sunday illusion. Compare two bars in a server aisle, then check your answer.

Read More
sql puzzle

SQL Puzzle – Retrieve the Unique Evens Under 10

November 21, 2023
Pinal Dave
SQL Puzzle
SQL Distinct

In that spirit, let me walk through a bite-sized SQL puzzle that helps reinforce some key concepts. Let us see Retrieve the Unique Evens Under 10 puzzle.

Read More
The Flight Connection Puzzle

SQL SERVER – The Flight Connection Puzzle

July 31, 2023
Pinal Dave
SQL Puzzle
CTE, SQL Server

Today we are going to see another such puzzle – The Flight Connection Puzzle. This blog post is going to be really fun blog post.

Read More
1 2 3 4 … 22 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com