As every database is different, you may need / want to update statistics more frequently.

From the sound of it, you're not hitting the threshold for an auto-update, but...

What does it say that, while I think I might know what the problem is, and I've already ginned up a solution and tested it, I'm not willing to post...

I suspect your problem is going to be in how your [DATE] field is stored.
Would I be correct in presuming that field is stored as either a DATE or...

So, I promised a photo of my home desk, and I'm delivering:

Not in the picture:
Several LEGO kits on top of the shelving unit (Helicarrier, motorcycle, bucket wheel...

While the idea sounds great in theory, it looks like (at present at least, on the Windows side,) this relies on a install of Windows Server 2016 Core (which is...

Rather late to this party, and I can't take pictures of my work desk, but it's relatively clean.  A Rubics Cube (1980s model,) a couple stress balls, and a few...

What I might suggest is, set up one pair of forums for "Previous Versions" for the people coming in still asking questions about SQL2000, etc.  But do away with the...