4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

Advanced Query Tuning Techniques

You identified a query that is causing performance issues, and your mission is to optimize it and boost performance. You looked at the execution plan and created all the relevant indexes. You even updated statistics, but performance is still bad. Now what?
In this session we will analyze common use cases of poorly performing queries, such as improper use of scalar functions, inaccurate statistics and bad impact of parameter sniffing. We will learn through extensive demos how to troubleshoot these use cases and how to boost performance using advanced and practical techniques. By the end of this session, you'll have a list of tips and techniques to apply on your environment.
Presented by Guy Glantser at SQLBits XII
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • SpeakerBIO
    guy_glantser.jpg
    Guy Glantser is the leader of the Israeli SQL Server user group and also the CEO of Madeira SQL Server Services. His career has been focused on SQL Server for the past 17 years, performing various database roles as either an on-site DBA, an external consultant or an instructor. Guy is involved in many activities in the SQL Server community. He occasionally speaks at community events, such as PASS Summit, Tech-Ed and user groups around the world. He also co-hosts the SQL Server radio show (www.sqlserverradio.com).
    http://www.madeirasql.com/author/guyglantser/ http://www.madeirasql.com/feed/
  • Video
    The video is not available to view online.