In addition to our official roster, SQLPerformance.com occasionally publishes content from community bloggers. Our current guest bloggers are mostly members of the SentryOne Product Advisory Council (PAC) who have offered to provide content from their unique real-world experience and perspective. Recent and upcoming guest bloggers include Derik Hammer, Dan Holmes, Andy Mallon, Monica Rathbun, Michael J. Swart, and Bert Wagner.
Dan Holmes (sql.dnhlms.com) talks about a solution he developed to manually coerce statistics to be more accurate and produce better, more predictable execution plans.
Benjamin Nevarez (@BenjaminNevarez) gives us some insight into the new cardinality estimator in SQL Server 2014 – both how it works as well as how to keep the functionality of the current version of the estimator.