Sounds like you have the Resource Governor in place. I'm not that familiar with it, but I would suspect there would be some way to set this query to not...

Well done and congratulations. Deliver on half the list and you've earned your raise for the year (and you have an agenda for next year).

I have not personally done an upgrade in that fashion. Based on my understanding of how it works, yes, but that's from reading documentation. If you want to be absolutely...

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....