SQL Tuning Overview

An overview on how to better utilize the persistence layer (DB) of your application. 

Why is my query running so slowly?

Should I add an index (and of what type) to my table?

How should I join my tables?

What are Partitions? Why should I use them?

How does the DB manage my queries? 

For these questions and more... :)