Episode 143 - A mash-up of mistakes all in one place

SQL Server Radio

Today, Guy has a lot of tips to share after reviewing one of those... "problematic" customer environments. Let's just say that he's got his hands full. But it's still fun, and you get to learn as well!

Relevant links:

• Forced Parameterization | Microsoft Docs
• Forced Parameterization Can Lead to Poor Performance | Microsoft Tech Community
• Why Multiple Plans for One Query Are Bad | Brent Ozar
• Relevant scripts from our Madeira Toolbox:
  • Find Unused Indexes
  • Find Redundant Indexes
• Join, Query, and Table Hints (Transact-SQL) | Microsoft Docs
• Indexed Views | Microsoft Docs
• Second Normal Form