APPLY Yourself

  • July 10, 2013 · 6:30 PM
  • Microsoft Office

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.

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.

Join or login to comment.

  • Surjit S.

    really helpful...

    July 11, 2013

  • Esther L I.

    Excellent speaker, friendly environment.

    1 · July 11, 2013

  • Sergey K.

    It was great!

    July 10, 2013

  • J. B.

    can't make it tonight, sorry

    July 10, 2013

67 went

Our Sponsors

People in this
Meetup are also in:

Create a Meetup Group and meet new people

Get started Learn more
Henry

I decided to start Reno Motorcycle Riders Group because I wanted to be part of a group of people who enjoyed my passion... I was excited and nervous. Our group has grown by leaps and bounds. I never thought it would be this big.

Henry, started Reno Motorcycle Riders

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy