David Morrison
tsqlninja.wordpress.com
Dave Morrison is a Principle Consultant for Coeo. Having worked in the IT industry for around 16 years his main area of expertise is SQL Server, BI and analytics technologies
SQLBits 2011
The Dark Arts-a.k.a Performance Tuning, indexing and query plans
This session will cover the "Dark Arts" of SQL Server namely performance tuning. Rather than a traditional look at query tuning it will focus on common misconceptions and a look a why sometimes you get query plans that do "odd" things
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