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."

Link: Query Parameterization and Plan Cache