United States























































Boost Your T-SQL with the APPLY Operator

48
Level 300
Add to My Learning Plan
Join now, for free!
Want to manage your learning plans?
Sign up for MVA and get this and other free benefits:
  • Take self-assessments
  • Join live events
  • Track your progress
  • Participate in forums
  • Get unlimited access to content
Maybe later
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

Sign back in
Want to access course content?
For this feature, sign back in to Microsoft Virtual Academy
Join now, for free!
Want to take a self-assessment?
Sign up for MVA and get this and other free benefits:
  • Manage your learning plans
  • Join live events
  • Track your progress
  • Get unlimited access to content
  • Participate in forums
Maybe later
                     
Message