title: SQL Forced parameterization recommendation from Azure
body: <p>I am using <code>Azure SQL</code> database in my project and in which some same set of queries are being executed very frequently. 
  Recently I received a performance recommendation saying - <code>Non-Parameterized queries are causing performance issues</code>.  and are suggesting to execute the following statement in my database.</p>
  
  <p><code>ALTER DATABASE [TestDB] SET PARAMETERIZATION FORCED</code></p>
  
  <p>I came to know that Forced parameterization may improve the performance of certain databases by reducing the frequency of query compilations and recompilation. 
  Also, it is known that stored procedures are executable code and are automatically cached and shared among user and it can prevent recompilations. </p>
  
  <p>Please help me with below-listed questions.</p>
  
  <p>1)Do turning database into Forced <strong>PARAMETERIZATION</strong> would work better than making frequently used queries into stored procedures?</p>
  
  <p>2)Is it safe performing the Forced Parameterization option in my database? </p>