That's a huge topic. First, you need to figure out what is causing the performance to slow down. Since, at this point, you're completely in the dark, I'd suggest taking...

Jack Corbett (3/16/2009)

---

I would hope that you were hired because they recognized a need for better database management, so I'd start by putting together a list of issues that you...

That's a huge topic. First, you need to figure out what is causing the performance to slow down. Since, at this point, you're completely in the dark, I'd suggest taking...

Do you mean in terms of licensing or in terms of physically can it be done? If the latter, yeah. You're talking Standard edition to Standard Edition. It shouldn't be...

The query was resolved through auto-parameterization because it was a trivial plan. A trivial plan is not kept in cache because there is almost no generation cost for them. That's...

Is BlogEntry by chance a view? Does the underlying table have a different datatype than what you have presented here?

I worked somewhere similar, everyone in the company had 'sa' privs on production. Made for a few entertaining late night phone calls followed by some serious screaming matches the next...

The issue is that you have either table or column collation settings on the first set of data are different than on the second set. You'll need to look at...

Only if you can't reapply them. It's fairly common practice for really large scale data moves to remove indexes and foreign keys at the beginning of the move and then...

moojjoo (3/14/2009)

---

The key question that I have still is what is the industry standard. An idea I am also thinking about is does it really matter leaving orpaned data...

Since it's not executing, can you post the estimated execution plan?

It sounds like you might be getting some blocking. Are there other processes hitting the table at the same time?

I think that's worth noting. Now we know it happens on two platforms....

If it's two different plans, that's probably the issue.

Make sure the same parameters are in use on both and make sure that both have updated statistics and defragmented indexes.

The very...

Different parameters?

Nope removing the certificate didn't fix the issue. That makes me feel better. There must be an alter database statement that removes the reference to encryption.