Performance

Free SQL Performance Scripts

This is why I love Twitter to keep up with the #SQLFamily. A question was asked by Chrissy LeMaire about scripts that Microsoft PFEs use…


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…


Get Started with Query Store

One of the newest features that everyone is talking about with Azure SQL Database or SQL Server 2016 is the Query Store which provides a mechanism of capturing…


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:…


SQL Server Startup Options

Startup options designate certain file locations needed during startup, and specify some server wide conditions. Most users do not need to specify startup options unless…


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…