Paul White (@SQL_Kiwi) walks through a new trace flag in SQL Server 2016 designed to yield better execution plans (and performance) for queries involving computed columns.
Guest author Derik Hammer (@SQLHammer) dismisses the common myth that table variables perform better than #temp tables because they are always in memory.
Aaron Bertrand (@AaronBertrand) begins a new series aimed at debunking common myths about SQL Server performance.
Rob Farley (@rob_farley) contributes to T-SQL Tuesday #87, showing how he would use AT TIME ZONE to simplify reports based on an end user's time zone.
In an effort to make leading wildcard searches sargable, Aaron Bertrand 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.
Aaron Bertrand (@AaronBertrand) starts digging deeper into the performance of string concatenation methods STRING_AGG and FOR XML PATH.
Aaron Bertrand takes an initial look at the performance of a new function, STRING_AGG, in SQL Server v.Next CTP 1.1.
After a recent conversation on Twitter, Aaron Bertrand shows where excessive comments in your stored procedures might have an impact on performance.