SQL SERVER – 2005 – Forced Parameterization and Simple Parameterization – T-SQL and SSMS | Journey to SQL Authority with Pinal Dave

SQL Server compiles query and saves the procedures cache plans in the database. When the same query is called it uses compiled execution plan which improves the performance by saving compilation time. Queries which are parametrized requires less recompilation and dynamically built queries needs compilations and recompilation very frequently. Forced parameterization may improve the performance… Continue Reading...

Source: SQL SERVER – 2005 – Forced Parameterization and Simple Parameterization – T-SQL and SSMS | Journey to SQL Authority with Pinal Dave