Paul White (@SQL_Kiwi) follows up a great post on calculating medians with some information on how locking can affect query performance, often undetected.
We have launched a new, bi-weekly newsletter to offer you the freshest content from our blogs and beyond. Subscribe at: https://sentryone.com/community.
Paul White (@SQL_Kiwi) demonstrates another case where a cursor might be the most efficient approach to solving a typically set-based problem: medians.
Tim Radney (@tradney) discusses some aspects of the msdb database that probably require more attention than they currently get in a lot of environments.