Can we make parameters optional?

  • Try checking the stored proc that returns the result set, run the sql profiler and see how the SP is running, look for any large table scans and see if the queries within the proc can be optimised.

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply