Return to Query Parameterization and Plan Cache
Query Parameterization and Plan Cache
Written by Guest Authors on 23 January 2007
This comes to us from the SQL Server Programmability and API Team Blog. They write "Using parameters or parameter markers in queries increases the ability of SQL Server to reuse compiled plans. There are two places where parameterization of queries can be done: on the client side application (or mid tier) or on the server side."