4.2 Tuning usp_SearchPostsByPostType
In usp_SearchPostsByPostType, people can query for PostTypeIds that have dramatically different numbers of rows in the Posts table. What makes matters even worse is that they’re passing in the name of the PostType, not the ID, so SQL Server doesn’t stand a chance of cardinality estimation.
To access this incredible, amazing content, you gotta get Mastering Parameter Sniffing – Live Classes + Instant Replay, 1 Year Access, Mastering Parameter Sniffing – Instant Replay Recordings Only, 1 Year Access or Recorded Class Season Pass, or log in if you already shelled out the cash.