Time And Relative Dimensions In Space...

Of course, I do have a sonic screwdriver in my backpack, so I might be biased.

Jack Corbett (3/17/2009)

---

GilaMonster (3/17/2009)

---

Bob Hovious (3/17/2009)

---

I'm still hoping to one day find sp_MSGoBackInTime documented in BOL. It is THE essential tool for recovering your database when you never...

Also remember that those estimated costs, are estimated, not actual. Execution can be quite a bit different than what is represented, and in a good way.

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