Performance

Wait Type Library

Wow, Paul Randal has put together probably the most comprehensive library of all wait types and latch classes that have existed since SQL Server 2005….


Wait Statistics Guide

Wait a minute… How could I have a week of favorite performance tuning resources without including one of my favorites. That’s right we are visiting…


Data Storage Internals

Wrapping up my week of Query Optimization page recommendations and while SQLity.NET  does have a lot of information on Query Optimization, it is an older series…


Query Optimization Papers

When talking about SQL Performance and Optimization, I always like to point to this excellent post by Benjamin Nevarez where he discusses which sources he used to…


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…