When does SQL Cache a Plan? 

Ever wondered under what circumstances SQL Server cache an execution plan. What is the difference between simple and forced parametrization. What are the disadvantages of plans being cached? Should I recompile a procedure or are there other options. How does plan caching differ between Adhoc queries vs stored procedure.
How does single use plans eat up memory. Is parameter sniffing the only issue we need to worry about when a plan has been cached? This video with a demo shows how SQL Server caches the plan and how this behavior can be manipulated by different settings.
Need more information? Visit www.enabledbus...
To know more about Jayanth Kurup visit www.jayanthkuru...
Jayanth is a Microsoft SQL Server trainer / consultant with over 15 years’ experience. He has worked with companies like Microsoft, IBM, HCL, Wipro, Well Fargo, Zeomega and many more. He is based out of Bangalore and a very active member of the SQL Server Community.
In this channel he covers complex topics related MS SQL Server , PowerBI , Azure , AWS , Powershell, SSIS , SSAS , SSRS , Machine Learning , AI , etc
You can also reach Jayanth via his LinkedIn profile below
/ jayanth-kurup