SQLBits 2020

Performance Mythbusters

Fast-paced session where Paul debunks a slew of myths and misconceptions around SQL Server performance!

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.