July 10, 2013 · 6:30 PM
Speaker: Brad Schulz
The APPLY clause was introduced to T-SQL in SQL 2005, and yet eight years later, relatively few people know about it. It's barely covered in SQL-related books and blogs, and yet it's an extremely powerful tool in constructing queries. This presentation offers lots of demos and will open your eyes to the potential of APPLY. Once you learn how to use it, you'll wonder how you ever lived without it.
- How to use APPLY (both CROSS APPLY and OUTER APPLY) and how it works
- Practical applications in using APPLY
- How APPLY can make previously unreadable queries clearer
- Additional skills in using Table-Valued Functions, Unpivotting data, and XML Shredding
Brad Schulz is a lead SQL Developer with DesignMind. He's a Transact SQL (T-SQL) performance tuning expert and also works with SSIS, Reporting Services, and Analysis Services.