Optimization

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…


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…