Learn from Hands-On Examples
This training is packed with practical demos showing off how the APPLY operator works in SQL Server. With ten separate demos on a range of topics, you will get a good understanding of how everything works.
Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. Knowing how and when to use APPLY can take your T-SQL and query tuning skills to the next level.
Over the course of this training, we will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting child records for each parent record, simplifying calculations, and much more.
Work on the Solution with Me
All of the T-SQL scripts used in demos are also available upon purchase of the course. Take the same code I use and learn at your own pace, taking apart and rebuilding examples.