isuckatsql (2/17/2010)

---

SQLBOT (2/17/2010)

---

DegreeOfParallelism="0" means unlimited parallelism (up to number of procs)

I do also note that parallelism = "false" in the xml of both. Not 100% sure if it means...

Thanks for the article.

Steve Jones - Editor (2/17/2010)

---

A restore is coming from IT. I have my fingers crossed that they do as I asked and not restore over this db.

Quick, everyone say a...

fruit

After the MaxDOP suggestion, try barking up Lowell's suggestion to output to file.

Both are good suggestions.

Another alternative is to determine if 500MB every 30 minutes is legitimate transactions.

I ran across a scenario where nearly 1TB was created a day in transactions due to some methods...

GilaMonster (2/17/2010)

---

Each PASS chapter gets, for the chapter leader. You have to be an affiliated...

I wonder if jcrawf02 had anything to do with the missing thread? He was the last to post there :Whistling:

Hmmm. I like Jeff's idea. I also like Emmitt's idea. Is this database starting fresh? Are the triggers truly needed for this data load?

If the triggers...

:ermm:

Wow, the thread was jealous?

Yup - looks like the...

cmallain (2/17/2010)

---

Or...has anyone considered that some of us do not know where to look and with being thrown into situations really do not have the time to do the...

Woot

Jeff Moden (2/16/2010)

---

I'm thinking that it will all boil down to the video card which is likely quite a bit cheaper on the server than on anything else. It...

The intent of this post was to try to get a feeler for anybody that might be in town that week. I am trying to line up some speakers...