Paul White (@SQL_Kiwi) kicks off a new blog series about ACID – atomic, consistent, isolated, durable – and how many people make incorrect assumptions about how these things work in SQL Server.
Continue Reading »Feb 272014
Feb 192014
Paul Randal (@PaulRandal) of SQLskills continues his series on knee-jerk performance troubleshooting. In this post, he talks about SOS_SCHEDULER_YIELD, and how to determine whether it is a wait to worry about in your scenario.
Continue Reading »Feb 142014
Benjamin Nevarez (@BenjaminNevarez) takes a close look at the new incremental statistics feature in SQL Server 2014.
Continue Reading »Feb 112014
SQL Sentry's Aaron Bertrand (@AaronBertrand) revisits an old post and explores approaches to calculating the median across partitioned sets.
Continue Reading »Feb 032014
Paul Randal (@PaulRandal) of SQLskills.com starts a new series on knee-jerk troubleshooting, discussing many areas where SQL Server folks jump to conclusions when trying to fix a performance issue.
Continue Reading »