Aaron Bertrand (@AaronBertrand) provides some details about the new look for SQLPerformance.com and some of the drivers behind the change.
Paul White (@SQL_Kiwi) demonstrates performance tuning a SQL Server execution plan as a whole, instead of honing in too narrowly on individual operators.
Paul White (@SQL_Kiwi) talks about coercing the optimizer into avoiding sorts, reminding us that sound indexing should still be our first line of attack.
Paul White (@SQL_Kiwi) looks at a couple of cases where – even though T-SQL is supposed to be a declarative language, and any query that uses the same logic and same semantics should ultimately lead to the same plan and comparable performance – rewriting queries can change the plan in dramatic ways.
Aaron Bertrand (@AaronBertrand) takes a closer look at some additional requirements for typical grouped concatenation queries in SQL Server.
Aaron Bertrand (@AaronBertrand) shows the safest and most efficient ways to perform grouped concatenation in SQL Server.