It sounds like it's doing everything through a single, logged operation. As long as you do this, you'll need this much space, as Lynn says. You either have to live...

I use to have A which caused me to do a lot of C, so I'd have to choose D - none of the above.

To my knowledge this works the same way as if you were restoring a 2000 backup, the binary being stored is converted to the new version by the restore process....

It's that second one. And just about as useful.

Ah, well, it is a Troll after all. Clarification is a wonderful thing.

Everyone knows the rule. Don't feed it more than we already have. It'll get hungry & go elsewhere.

Perry Whittle (4/19/2010)

---

Grant Fritchey (4/19/2010)

---

I agree with almost all of the advice here with one exception... DTA is a pile.

For anything beyond the simplest mom&pop sized database, it's recommendations...

CirquedeSQLeil (4/19/2010)

---

So when we search for something on google - do we say google it or googling it?

And same with bing - do we bing it or are we binging...

anthony_merriwether (4/19/2010)

---

Please do not resort to name calling. Seems that a few of you display your intellect in this way, which does not surprise me in the least. If...

anthony_merriwether (4/19/2010)

---

This is for all of you who are perturbed with the postings that you are seeing. I have read your replies and feel that you are all out of...

I agree. Is that the size of the database you want? If so.... there you go. If not, yeah, you might want to shrink the files. Regardless, once you backup...

You won't be able to disable by job across multiple servers in one step. Probably the best way to do it would be to write a PowerShell script that walked...

There could be any number of reasons and without more detail, it will be very difficult to guess.

The first two guesses that come to mind are either parameter sniffing or...

No, there should be no connection to the production system while you are testing the dev system.

Be very cautious about applying the DTA recommendations. It's notorious for picking poor...

I agree with almost all of the advice here with one exception... DTA is a pile.

For anything beyond the simplest mom&pop sized database, it's recommendations are so horrendously dangerous...

I'm surprised you're not getting errors, because you should

CREATE TABLE #tblPartners

(

c_id int,

...