Brent starts with sp_BlitzIndex, then examines the indexes on the Badges, Comments, Posts, and Votes table to drop the wrong ones and add the right ones. Then he reruns the load test again to see the differences.
I make Microsoft SQL Server go faster. I love teaching, travel, cars, and laughing. I’m based out of Las Vegas. He/him. I teach SQL Server training classes, or if you haven’t got time for the pain, I’m available for consulting too.
