About the Presentation
Apply Here
MVP Kent Waldrop takes a look at the CROSS APPLY and OUTER APPLY operators and steps through a number of scenarios where these two operators might be useful. Topics included include use of the APPLY operators with table functions, substituting inline table functions for scalar functions to improve performance, use of the APPLY operator in conjunction with XML and more.
Session Level: Beginner
Kent Waldrop
I have worked with MS SQL Server going back to version 6.0. Before that I worked with Sybase for about 5 years. I've written thousands of stored procedures, functions and triggers and a few hundred DTS packages. I was on a team at CSX that won an ICSA Award of Excellence. I have about 3000 posts on Microsoft’s SQL Server MSDN forums -- most of these posts related to transact SQL. I received MVP awards in 2008 and 2009. I like snorkeling, swimming, bicycling, ice skating and bringing out th
Contact URL: