Pete,
Thanks for your feedback.
peterzeke (8/14/2013)
1) Did you actually modify the query to handle parameter sniffing? From my own experience, I've had situations where parameter sniffing was the problem -- modifying a stored proc to include a declared variable that gets assigned the parameter value that is initially passed to the stored proc solved my performance problems.
Yes; at the top of the stored proc, I set local declared variables equal to the parameters and then use the local variables in the WHERE clause of the query.
2) I've also had problems with a slow report if the sql was returning a dataset as "Select * From ...." Changing the "*" to an explicit list of fields has proven beneficial.
No SELECT * in the query either -- I explicitly list the fields.
Thanks,
Rob