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.
Christina E. Leo
Christina Leo is a Boston based independent consultant specialising in T-SQL development and performance tuning. She's currently working with Adam Machanic on an investment fund management data warehouse project. Previously, she worked as a database developer for Jack Henry & Associates. She actively participates in the SQL Server community speaking at local user group meetings and SQL Saturdays. She’s also one of six Idera ACEs (Advisor and Community Educator) for 2012-2013.
UID:SQLBITS1500SEQUENCE:0 DTSTAMP:20130619T092405Z END:VEVENT END:VCALENDAR