You've been writing queries for a while but you find yourself needing them to run faster, how do you measure them and increase performance?

In this session we'll go through some techniques to give you an idea what's happening inside the SQL Server engine and improve your queries. We'll be going a few topics to give you a understanding on how you can increase performance.

- Execution Plan basics and how to read them
- SET Statistics options and tools
- Some common mistakes to avoid (cursors, scalar functions etc)
- Indexing and how it affects your queries
- SARGability - what it means and why it can make a massive difference

You should leave this session with the ability to analyse your own (and other's) queries and see where you might have performance bottlenecks and fix them!