Paul White (@SQL_Kiwi) follows up a great post on calculating medians with some information on how locking can affect query performance, often undetected.
Paul White (@SQL_Kiwi) demonstrates another case where a cursor might be the most efficient approach to solving a typically set-based problem: medians.
Paul White (@SQL_Kiwi) concludes his two-part series on SQL Server sort internals, including two new classes specific to In-Memory OLTP in SQL Server 2014.
Paul White (@SQL_Kiwi) rolls up his sleeves in his usual way, showing off the debugger several times while explaining the internals of SQL Server sorts.
Paul White (@SQL_Kiwi) follows up on his thorough breakdown of indexed view maintenance with the details of a bug that can render an indexed view incorrect.
Aaron Bertrand (@AaronBertrand) walks through several potential causes for different plans and/or performance for the same database on two "identical" servers.
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.
