Home Forums SQL Server 2008 T-SQL (SS2K8) Techniques for improving stored procedure performance RE: Techniques for improving stored procedure performance

  • Does your proc have input parameters which then used directly in WHERE clauses or JOINS?

    If so, try to declare local variables at the top of proc, assign them to input param values and use them instead. You may find it will help you better than using WITH RECOMPILE.

    Do you run both ways in SSMS?

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]