17th - 19th July 2014

The International Centre, Telford

Platinum Sponsor

The Dark Arts-a.k.a Performance Tuning, indexing and query plans

In this session, rather than a traditional look at "query tuning" I will challenge some of the common misconceptions around tuning queries. It will also go into some detail around why sometimes the query optimiser chooses "odd" plans which perform poorly and how to help the optimiser choose a better plan. It will also take a brief look at SARGability, indexing and "inverse predicates" The session will mainly be held in management studio
Presented by David Morrison at SQLBits VIII
  • Downloads
  • SpeakerBIO
    david_morrison.jpg
    Dave Morrison is senior BI consultant for Itelligence. Having worked in the IT industry for around 14 years his main area of expertise is SQL Server, namely TSQL, query optimisation, indexing, performance tuning and internals etc.
    http://tsqlninja.wordpress.com
  • Video
  • Session Files Explorer
    The network name cannot be found.