Tag: Apply

SQL

Performance Considerations using APPLY

Post author By Andy B.
Post date Jan 31, 2023
No Comments on Performance Considerations using APPLY

In the previous post we looked at how to use the CROSS APPLY and OUTER APPLY operators as alternative to a JOIN in queries with some examples. As we wrapped that up I also mentioned that there can be drawbacks to using APPLY in our queries, particularly when we’re working with large data sets. The issue is due to the way that the right hand […]

Tags Apply, Cross Apply, Join, Outer Apply, Performance, Querying, SQL, SQL Server

SQL

Using Cross Apply and Outer Apply

Post author By Andy B.
Post date Jan 24, 2023
No Comments on Using Cross Apply and Outer Apply

When joining data in SQL we have a number of options to us including INNER and OUTER joins, but one of the ones I tend to use less frequently is the APPLY operator, specifically the CROSS APPLY and OUTER APPLY operators. As with other types of joins they operate slightly differently and have considerations which should be taken into account when deciding on the output […]

Tags Apply, Cross Apply, Join, Outer Apply, Querying, SQL