death to sql server (part 2)

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.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s