United States























































Total Activity

2,245,971
students registered
394,855
students registered

Connect with MVA

Boost Your T-SQL with the APPLY Operator

28
Total points
Average User Rating:
(33)
0%
Complete
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
Modules
01 | ​APPLY, Described
9 Points -  Level 300
02 | APPLY Boosts Various T-SQL Features
9 Points -  Level 300
Related Course Resources & Events
Next Steps
 
                     
Subject
To
Message
 
                     
Email