Performance

Working with Wait Statistics

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…


Query and Join Hints

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…


What is Parameter Sniffing?

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…


SQL Query Processing

This post will describe how a SQL Server will PROCESS a query. The first time through running an Ad Hoc query or Stored Procedure, SQL…