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.
Derik Hammer (@SQLHammer) sets out to disprove another pervasive performance myth : TRUNCATE is faster than DELETE because it isn't logged and can't be rolled back.
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.