Optimization

SpecTECHular recordings

Recordings are now available from the October 12th New Horizons SpecTECHular event. You can find my session on “The Vocabulary of Performance Tuning” here.


Automatic Tuning in SQL 2017

 Automatic tuning in SQL Server 2017, notifies you whenever a potential performance issue is detected, and lets you apply corrective actions, or lets the Database…


October – IndyPass

Identifying and Fixing Parameter Sniffing (Tuesday October 18th, 2016 – 6:00 pm) Presenter: Brent Ozar from Brent Ozar Unlimited You swear nothing changed – but…


FREE Plan Explorer

SQL Sentry is introducing the new unified Plan Explorer! This edition includes all features of Plan Explorer PRO, plus two new and incredibly powerful features:…


The PROCESS of Queries

If you can’t make it to a SQL Saturday to see my presentation on The PROCESS of Queries? That is OK. Because I made it…


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…


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…