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