Using Dynamic Plan Stability to provide consistent SQL performance

Understand how you can use dynamic SQL without the risk of performance degradation and be as stable as static SQL.