A SQL Server Query Plan Riddle

Description:
In this video, I present a riddle that challenges your understanding of SQL Server query plans and hints. If you enjoy puzzles or are curious about the intricacies of how SQL Server processes queries, stay tuned as I share two seemingly similar queries but with one crucial difference. The first query runs smoothly with a hash join hint, while removing just one column causes an optimizer error-quite a perplexing scenario! Your task is to figure out why this happens and provide a logical explanation for the behavior. If you're eager to test your SQL Server knowledge or simply enjoy a good riddle, consider signing up for a membership; the more members we have, the more riddles I'll share. For those who prefer less puzzling content, feel free to leave a comment requesting no more riddles and instead offering a discount code for my training courses, which you can access through the video description link.

CHAPTERS

00:00:00 - Introduction
00:00:29 - Riddle and Membership Offer
00:01:15 - Office Hours Episode Link
00:01:36 - Query Plan Riddles for Hire
00:02:15 - Services Offered
00:02:24 - Training and Pricing
00:02:35 - Upcoming SQL Saturday, New York City
00:03:00 - Redgate Pass on Tour
00:03:08 - Dallas Event
00:03:13 - Amsterdam Event
00:03:35 - Seattle Event
00:04:00 - Two Queries for Riddle
00:04:46 - First Query Execution
00:05:15 - Second Query Error
00:06:32 - Mission Acceptance
00:07:02 - Demo Database Link

━━━━━━━━━━━━━━━━━━━━━━━━━━
???? TRAINING & COURSES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Get AI-Ready With Erik
https://training.erikdarling.com/get-ai-ready-with-erik?coupon=AIREADY

SQL Server Performance Engineering Course
https://training.erikdarling.com/sql-server-performance-engineering?coupon=ENGINEERING

Learn T-SQL with Erik
https://training.erikdarling.com/learn-t-sql-with-erik?coupon=ADVANCEDTSQL

Everything Bundle:
https://training.erikdarling.com/?coupon=SPRINGCLEANING

━━━━━━━━━━━━━━━━━━━━━━━━━━
????️ CONSULTING & SERVICES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Need SQL Server performance help?
https://training.erikdarling.com/sqlconsulting

━━━━━━━━━━━━━━━━━━━━━━━━━━
???? CONNECT
━━━━━━━━━━━━━━━━━━━━━━━━━━
Ask questions at Office Hours
https://erikdarling.com/officehours/

Become a channel member
https://www.youtube.com/@ErikDarlingData/join
━━━━━━━━━━━━━━━━━━━━━━━━━━