SQL Server Performance

Binding Variables

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by arunyadav, Jun 15, 2009.

  1. arunyadav Member

    Hello All,
    To increase performance of dynamic queries, variable binding is used. Can you please tell me the syntax/ example of doing it??

  2. Sandy New Member

    Hi Arun,
    What exactly you are looking for. Can you bit more specific?
  3. FrankKalis Moderator

    Yes, I think you need to give some more information. Would guess you're talking about the client side, not server side.
  4. arunyadav Member

    In our organizations we have reporting related Stored procedures in which dynamic SQL is used. Variable binding can be used so that execution plan can be reused. Check the below link for how it is done in Oracle. I wanted to know how it could be done in SQL Server 2005/2008 to increase performance of dynamic queries.
    Dynamic SQL with Bind

  5. FrankKalis Moderator

Share This Page