Glenn Berry (@GlennAlanBerry) explains why you need to be very careful about your physical processor choice when configuring servers to run SQL Server 2016 Standard Edition.
Aaron Bertrand (@AaronBertrand) kicks off his "Performance Myths" series, showing a "redundant" non-clustered index outperforming the clustered index with the same key.
In an effort to make leading wildcard searches sargable, Aaron Bertrand (@AaronBertrand) plays around with a trigram-type implementation in SQL Server.
Aaron Bertrand acknowledges that DISTINCT and GROUP BY are usually interchangeable, but shows there are cases where one performs better than the other.
Erin Stellato (@erinstellato) takes a look at the new COMPRESS and DECOMPRESS functions, comparing their impact on space and performance to traditional data compression.
Auto-correlate and track performance for all of your Windows processes and services, right now or historically. 
