When should I use CROSS APPLY over INNER JOIN?

Channel:
Peter Schneider
Subscribers:
4,140
Published on ● Video Link: https://www.youtube.com/watch?v=rUWmkVIcAiY


Duration: 7:49
2 views
0

When should I use CROSS APPLY over INNER JOIN?
I hope you found a solution that worked for you :)
The Content (except music & images) is licensed under (https://meta.stackexchange.com/help/licensing)CC BY-SA
Thanks to all those great people for their contributions!

(stackoverflow.com/users/111934/jeff-meatball-yang)Jeff Meatball Yang
(stackoverflow.com/users/55159/quassnoi)Quassnoi
(stackoverflow.com/users/3312636/sarath-subramanian)Sarath Subramanian
(stackoverflow.com/users/227755/nurettin)nurettin
(stackoverflow.com/users/283879/mtone)mtone
(stackoverflow.com/users/6938599/apneal)Apneal
A special thanks goes out to the (https://stackoverflow.com/questions/1139160/when-should-i-use-cross-apply-over-inner-join)Stackexchange community

I wish you all a wonderful day! Stay safe :)

performance sql cross-apply sql-server t-sql



Other Videos By Peter Schneider


2023-12-03Convert a String representation of a Dictionary to a dictionary
2023-12-03Ethereum: How can a bytes32 variable have a custom method (i.e., verifyCalldata)?
2023-12-03Dba: Is there a keyboard shortcut to open a registered server?
2023-12-03Difference between CR LF, LF and CR line break types
2023-12-03Why would a JavaScript variable start with a dollar sign?
2023-12-03How to "comment-out" (add comment) in a batch/cmd?
2023-12-03Apple: Is there an app that replaces the phased-out TouchBar?
2023-12-03Can I call a constructor from another constructor (do constructor chaining) in C++?
2023-12-03Returning JSON from a PHP Script
2023-12-03Parameterize an SQL IN clause
2023-12-03When should I use CROSS APPLY over INNER JOIN?
2023-12-03Is there any difference between a GUID and a UUID?
2023-12-03Get current directory or folder name (without the full path)
2023-12-03Format JavaScript date as yyyy-mm-dd
2023-12-03pip install from git repo branch
2023-12-03Wordpress: add custom image to bottom of wordpress default login screen
2023-12-03Raspberrypi: How can I generate a hardware PWM on Raspberry Pi 4 using Python?
2023-12-03Unix: raise network interfaces - debian 12
2023-12-03Is there a name for this "fill in the blank" algorithm?
2023-12-03Problem with TWinControl component not responding to form resizing
2023-12-03Long string matching in the same or other records


Tags:
performance
sql
cross-apply
sql-server
t-sql