jgenovese (11/17/2012)
I believe it is multi-lineNote that the query did not change -- the emphasis is on what could have happened that weekend that caused the query to double in time
You are being tunnel-visioned. It may not be just what happened that weekend. Maybe you reached a tipping point with the data that caused the query to slow down, not just the index rebuild and stats updates. As Jeff indicated, you need to look at this as if the query did change and needs to be tuned.