17th - 19th July 2014

The International Centre, Telford

Platinum Sponsor

Why APPLY?

Most T-SQL developers know that the APPLY operator can be used
to invoke a table valued function. But did you know that it can also be used to
join to derived data sets, return multiple columns from a sub-query, shred XML,
create working columns for use with the WHERE and GROUP BY clauses, and replace
the UNPIVOT operator? If not, then why not take your skills to the next level, and
come see each use case in action, using real-world examples. You’ll leave the
session with thorough understanding of the full potential of this versatile
operator, as well as a few new tricks up your T-SQL sleeves.

Presented by Christina E. Leo at SQLBits XI
Tags (no tags)
  • Downloads
    Samples available Demo Code 136 KB
    Video available MP4 Video Med 156 MB
    Video available MP4 Video HD 431 MB
  • SpeakerBIO
    Christina_E_Leo1.jpg

    Christina Leo is a Netherlands based, independent consultant specializing in T-SQL development and performance tuning. She happily shares her 14 years of technical experience with the SQL Server community by teaching at local and international SQL Server user group meetings and technical events, including multiple SQL Saturdays, SQL Bits, TechEd Africa, and the PASS Summit.

  • Video
    The video is not available to view online.
  • Session Files Explorer
    The network name cannot be found.