This one isn’t a rant, just another head-scratching-that’s-an-odd-thing-to-do kind of post.
One of the main scripts was running slow tonight that gets hit on a regular basis, and we couldn’t figure out why.
So, we do what we do when we aren’t sure what to do — we reindex the table. That’s the first general fix we like to do. Turns out, that fixed it in this case, as well.
What had changed recently you might ask (and well so)? We added a column to one of the database tables.
I guess that was too much of a strain for SQL Server.