JOINS for fun and profit
(Disclaimer: This talk is not for anyone who always writes a perfect JOIN statement from the very start) There are many different ways to join data between objects. Sometimes there is a clear best way. Other times, there are several different ways. Often those different ways are just a matter of style because the compiler understands what is going on and can translate them all down to the same performant execution plan. We'll look at different styles of joins and many different ways to use and abuse them, all for fun and learning to make you a better sql developer.
Mike is the leader of the Austin SQL User Group
- Capitol Area Central Texas Users of SQL Server 80 Recordings
Apr 19, 2022
- SQL 23 Recordings