Viewing 3 posts - 1 through 4 (of 4 total)
Thanks everybody for all of your tips.
We have a scheduled job that updates stats on this table multiple times per day, and we haven't had a problem since then.
February 9, 2010 at 4:21 pm
#1116455
GSquared - Thanks for the tip! If we discover it is a problem with the execution plan, would you suggest simply using the RECOMPILE hint as part of the query?...
December 30, 2009 at 2:43 pm
#1097676
Gail - Part of the filter is absolutely looking at the two date columns to grab the latest records.
Amazing insight! What does this mean to you?
December 30, 2009 at 2:37 pm
#1097671