Episode 143 - A mash-up of mistakes all in one place
- Author
- SQL Server Radio
- Published
- Mon 29 Aug 2022
- Episode Link
- http://sqlserverradio.com/episode-143-a-mash-up-of-mistakes-all-in-one-place
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:
- Join, Query, and Table Hints (Transact-SQL) | Microsoft Docs
- Indexed Views | Microsoft Docs
- Second Normal Form
