Aaron Bertrand talks about the top 10 wait types we see among our SentryOne customer base, and where to turn when you're experiencing one of them on your own system.
Aaron Bertrand acknowledges that DISTINCT and GROUP BY are usually interchangeable, but shows there are cases where one performs better than the other.
Tim Radney of SQLskills gives an overview of his approach to SQL Server performance tuning, from system configuration, to I/O latency, to high cost queries.
Erin Stellato (@erinstellato) continues her popular series on proactively monitoring SQL Server, this time focusing on keeping your eye on wait statistics.
Paul Randal (@PaulRandal) explains how to tell when CXPACKET waits are actually a problem (because, usually, they are just an indication of parallelism).
Paul Randal (@PaulRandal) of SQLskills provides some thorough and helpful tips on reducing or eliminating the impact of index fragmentation in SQL Server.
