Viewing 2 posts - 1 through 3 (of 3 total)
That was it. I made the variable into a parameter and the execution plan and query time was drastically improved. Thanks for the help.
Troy
October 15, 2010 at 6:46 am
#1237470
It's actually in a function... the @TodaysDate parameter is always set to a date, it will never be null.
Based on that do you think paramter sniffing is still the issue?
October 14, 2010 at 12:49 pm
#1237144