It's amazing how many myths and misconceptions have sprung up and persisted over the years about SQL Server. After 20 years helping people out on forums, newsgroups, and customer engagements, Paul's heard it all – especially related to performance. Are temporary tables always a good idea for performance? Does using SSDs mean no fragmentation issues and no performance problems? Will adding memory always improve server performance? These are just a few of many, many myths that Paul will debunk in this fast-paced session focused on what really helps SQL Server performance.

Presented by Paul Randal at SQLBits 2020