Query Parameterization and Plan Cache
By Guest Authors
on 23 January 2007
| Tags:
Query Tuning
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."
