SentryOne Team Blog (blogs.sentryone.com)

Tag : optimization

Paul White : Optimizing Update Queries

Paul White (@SQL_Kiwi) spends some time optimizing update queries in order to explore some SQL Server internals.

Paul White : Locking and Performance

Paul White (@SQL_Kiwi) follows up a great post on calculating medians with some information on how locking can affect query performance, often undetected.

Bad habits : Looking for optimizations in all the wrong places

Aaron Bertrand (@AaronBertrand) continues his "bad habits" series; in this installment, he discusses ten common cases of misplaced optimization.