Again, Thanks so much for the tips on how to get accurate work load cost when comparing 2 queries. I really really appreciate it!!

I came across something that got me to thinking about your earlier comment on work load percentage cost (relative to batch). Reason is, I often compare the execution plans...

This was really bugging me so thanks so much for the explainations......I now understand parameterized query plans better.

Thanks!!!

Thanks for the quick response...I really appreciate it. I think I understand your reply.

So for future queries where I am using declared variables I should include "recompile" as...