Here I will post resources and dicussions regarding SQL Server performance tuning and optimisation.

Structural/Design Focused Optimisation

Query Specific Optimisation

Troubleshooting Performance

Misc