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.