United States























































Boost Your T-SQL with the APPLY Operator

39
 
You must sign in and try the content to rate it. Do you want to sign in?
 
Level 300
Add to My Learning Plan
18 Points
Completion bonus 10 points
0% complete

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

                     
Message