A list of favorite blog posts would not be complete without a trip over to SQL Skills and Paul Randal where he asks,”How many times have you walked up to a SQL Server that has a performance problem and wondered where to start looking?”  Well the answer he gives us…

Day two of my favorite posts on SQL Server Query Optimization takes us to Simple Talk and a 2009 blog post from Grant Fritchey and Controlling Execution Plans with Hints. To be honest, while you are there I would check out his book on SQL Server Execution Plans.

Sometimes there are really great posts that explain a topic so well, it is worth sharing. For this next week, I am going to post some of my favorites regarding SQL Server Performance Optimization. Here is a post on Parameter Sniffing where Jes Borland talks about the Elephant and the Mouse problem.