United States

Total Activity

students registered
students registered

Connect with MVA

Boost Your T-SQL with the APPLY Operator

Total points
Average User Rating:
Bonus points for course completion: 10
Add to My Learning Plan
You must sign in and try the content to rate it. Do you want to sign in?

Need creative solutions to T-SQL issues? Get them from Itzik Ben-Gan, one of the world's foremost authorities, along with Microsoft Program Manager Umachandar Jayachandran. These experts demonstrate the APPLY operator, a T-SQL feature that can be used to solve a wide variety of problems. What's especially interesting about APPLY is how it can be used in conjunction with many T-SQL features. To demonstrate this aspect of APPLY, the session tracks the operator through time, discussing features that were initially introduced in different versions of SQL Server (7.0, like TOP, through 2012, like OFFSET-FETCH), some of which are widely used today. For each feature, the session describes its shortcomings and then shows how to use APPLY to overcome it and to improve the feature.

All demonstrations are performed on SQL Server 2014.

Instructors | Itzik Ben-Gan - SolidQ T-SQL Trainer; Umachandar Jayachandran - Microsoft Program Manager

Course owner: Dean Of Colleges
01 | ​APPLY, Described
9 Points -  Level 300
02 | APPLY Boosts Various T-SQL Features
9 Points -  Level 300
Related Course Resources & Events
Next Steps