Christina E. Leo
Christina Leo is a Boston based independent consultant specialising in T-SQL development and performance tuning. She's currently working with Adam Machanic on an investment fund management data warehouse project. Previously, she worked as a database developer for Jack Henry & Associates. She actively participates in the SQL Server community speaking at local user group meetings and SQL Saturdays. She’s also one of six Idera ACEs (Advisor and Community Educator) for 2012-2013.
Learn to create and customise TSQL scripts for capturing SQL Profiler data in a server side trace. Examine methods for stopping, starting and storing these traces, and finally look at free tools available for analysing the captured data.
In this session, we'll examine the query plan cache to see what plans are saved, what plans are reused, when plans are recreated, methods for observing the contents of the plan cache, and finally,
methods for manipulating plan reuse and recreation.
Most T-SQL developers know that the APPLY operator can be used to invoke a table valued function. But do you know the other ways APPLY can be used? Come learn five additional use cases and leave with a few new tricks up your T-SQL sleeves.