4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

Query Optimizer Internals : Traceflag fun

The query optimizer is at the heart of SQL Server. Without it SQL Server would be a vastly inferior product, queries would have to be manually tuned at each and every turn, and generally speaking, the optimizer protects us from the complexities and mechanics involved. Much of the optimizer's internal workings are hidden from the user, but can be revealed by using a selection of undocumented trace flags to gain further knowledge and insight into how your queries and data are processed to create a plan.

This session will be a deep dive into the optimizers' internals and not for the feint of heart. 
Presented by Dave Ballantyne at SQLBits XII
  • Downloads
    Slide deck available Slide deck 1.7 MB
    Video available MP4 Video HD 524 MB
  • SpeakerBIO
    Dave is a freelance SQLServer database developer / designer and has been working in the IT field for over 20 years,  the past 15 of which has been specialising within SQLServer environment. 
    http://www.clearskysql.co.uk http://dataidol.com/davebally/feed/
  • Video