I discuss a handful of reasons "identical" queries might yield multiple plans, contributing to plan cache bloat.

Tip: Over 40 queries to find tables with or without a certain property

Tip : Verify the databases a login can see – and why