Bob,

This is a bit opposite to your question, but may be helpful to read as well
http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/b8a17801-ea8b-415c-9207-308b6187d83e

>Naomi,
>
>Thank you for the link. That is useful information.
>
>
>>Bob,
>>
>>I think you're ruuning into parameter sniffing problem
>>http://pratchev.blogspot.com/2007/08/parameter-sniffing.html
>>