Thanks to you all. Rebuilding the indexes and updating the stats seem to have cured most if not all the trouble. Further testing will tell for sure. And it looks...

I do mostly contract/consulting development work, so even acting as a Deputy DBA (I like the term), I don't typically have long-term responsibilities for the database. But I like repeat...