SQL Optimization

Here’s collection of links and thoughts about how to perform optimization of a SQL Query and performance tuning of SQL Server: