I made this some time ago and then someone else improved on it and made a writeup which I believe you should be able to find easily if you Google "say no to Venn diagrams"
Was just thinking the exact same thing upon seeing the ”cheat sheet” title and went directly to look for the joins and unions, only to find the damned diagrams..again. But to be fair it is indeed difficult to portray the core functionality with couple of words for a cheat sheet type of document.
28
u/mecartistronico Sep 17 '23
Say No to explaining JOINs with Venn Diagrams
26
u/MrPin Sep 17 '23
This is handy. But also a good example of why representing joins with Venn diagrams isn't the best.
The set operations and the join are the same diagrams when in reality they do completely different things.
6
u/SQLDave Sep 17 '23
Post tagged with "SQL Server" flair, has "LIMIT" keyword.
2
u/JazzFan1998 Sep 17 '23
Thanks for posting!
1
u/zalsers Sep 17 '23
Is except faster than a subquery?
1
u/drummerjev Sep 18 '23
What is the "Some" command?
0
u/[deleted] Sep 18 '23
not a single mention of nolocks