APPLY Yourself

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.https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRgH59erjSvKdHtZMFj9rIVElwgEURqkwCqLqB9JxOQ3yzYc4kU
You'll learn:

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.