Next Meeting: Tue, Sep 27 2016
Kevin Feasel presents APPLY yourself
Event Type: In-Person
Online Meeting URL: None
UTC : Tue, Sep 27 2016 22:00 - 00:00
Event Time : Tue, Sep 27 2016 18:00 - 20:00 Eastern Daylight Time
Your Local Time: Tue, Sep 27 2016 22:00 - 00:00
4821 Koger Blvd
Greensboro, North Carolina
Kevin Feasel, Database Engineer Catallaxy Services
Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.
Kevin Feasel is a Data Platform MVP and database engineer with Catallaxy Services, where he specializes in T-SQL and SSIS development, performance tuning, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (curatedsql.com) and a contributing author to Tribal SQL (www.tribalsql.com). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.