tag:blogger.com,1999:blog-30089534.post115247792793197699..comments2008-09-24T15:17:30.459+01:00Niall Flanaganhttp://www.blogger.com/profile/09326614446931344176noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-30089534.post-22271414375169075452008-09-24T15:17:00.000+01:002008-09-24T15:17:00.000+01:00Can you clarify the issue that leads to the parameter sniffing issue. It seems to me that recompiling the stored procedure (which would occure when the suggestion is implemented). I've not seen an issue like this that I wasn't able to resolve by adding or rebuilding indexes and then recompiling the stored procedures. Rebuilding indexes on a production environment is not always an immediately available option, is this resolution a means to resolve the issue without having to rebuild indexes?william.delaunehttp://www.blogger.com/profile/05947945218131583622noreply@blogger.com