Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 Article: Query Parameterization and Plan Cache

Author  Topic 

Ask SQLTeam Question

0 Posts

Posted - 2007-01-23 : 21:01:14
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.

Article Link.


- Advertisement -