why?
Not my project so they told me to recompile the indexes and the catalog, no luck...
You go to google, you read, no luck.
You decide to look at the query ... converting dates to varchar, when the day is bigger than X it gets slow.
I do have a problem with queries and dates, i'm glad i'm not the only one.