I discuss a handful of reasons "identical" queries might yield multiple plans, contributing to plan cache bloat.
Tip : Over 40 queries to find SQL Server tables with or without a certain property
Microsoft has released Cumulative Updates for SQL Server 2012 Service Pack 1 and Service Pack 2. Note that RTM is no longer supported and you should be moving to the SP2 branch soon. SQL...
Tip : Verify the databases a SQL Server login can see – and why