Aaron Bertrand (@AaronBertrand) kicks off his "Performance Myths" series, showing a "redundant" non-clustered index outperforming the clustered index with the same key.
Aaron Bertrand acknowledges that DISTINCT and GROUP BY are usually interchangeable, but shows there are cases where one performs better than the other.
Aaron Bertrand (@AaronBertrand) follows up on a recent post about DATEFROMPARTS() with a deeper look into the estimates and potential mitigation techniques.
For this month's T-SQL Tuesday, Rob Farley takes a look at a couple of unexpected aspects of query plans you might observe when using Temporal Tables in SQL Server 2016.
Rob Farley (@rob_farley) digs deeper into seeks and actual rows read, demonstrating a case where you want a non-sargable expression in the WHERE clause.
