17th - 19th July 2014

The International Centre, Telford

Platinum Sponsor
Christina_E_Leo1.jpg

Christina E. Leo

Christina Leo is a Netherlands based, independent consultant specializing in T-SQL development and performance tuning. She happily shares her 14 years of technical experience with the SQL Server community by teaching at local and international SQL Server user group meetings and technical events, including multiple SQL Saturdays, SQL Bits, TechEd Africa, and the PASS Summit.

Christina E. Leo has submitted 2 sessions for SQLBits 12, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

Sets are king when it comes to SQL Server, but sometimes you need to see data row by row. Window Functions help you get the best of both worlds. Learn when and where these functions can help you get what you need without compromising performance.
This all-demo session will explain the logical processing hierarchy that the Query Optimizer must follow in order to return an accurate result set. By the end of this session you will have the foundation knowledge you need to write better queries.

Previous Sessions

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.