SQL Server caches execution plans by query, but even the tiniest differences between queries can result in different plans being cached. Brent demos with sp_BlitzCache.
On this page of the site you can watch the video online Silent SQL Server Demo: The Plan Cache with a duration of hours minute second in good quality, which was uploaded by the user Brent Ozar Unlimited 06 October 2016, share the link with friends and acquaintances, this video has already been watched 6,294 times on youtube and it was liked by 73 viewers. Enjoy your viewing!