Perry Whittle (1/11/2012)

---

The big advantage of Raid 10 is you can lose up to half the disks as long as no mirrored pair fail and the array will still operate,...

I really don't like the questions about "best" practices for storage from MS. There is seldom enough information presented to properly answer those questions.

Sure, RAID10 offers better protection. ...

Any way you can attach the exec plan for the one that is taking a long time to run?

I think the clues to improving will be found there.

Hope that helps.

DeanORenO

you people on this forum are always complaining about the questions that are asked on the forums, either you complain that they are too simple, and that the poster should...

haha

john.arnott (1/11/2012)

---

SQLRNNR (1/11/2012)

---

Evil Kraig F (1/11/2012)

---

Is it bad I originally misread the link and thought it said 'sex frustrations' as the folder?

😀 I've been...

shrink

Evil Kraig F (1/11/2012)

---

Is it bad I originally misread the link and thought it said 'sex frustrations' as the folder?

😀 I've been tempted to...

Eshika (1/11/2012)

---

In Tables 1&3 there are over 2000 records,tables 2 & 4 there are over 20 million records.

The trigger should be fired on an update, there are no recursive triggers...

3graces (1/11/2012)

---

You guys are having way too much fun at my expense. I moved the question to the "General" forum; posted to this forum by mistake. What can...

Has the on-site dba been able to successfully run the package from BIDS?

If you want to recreate the exact schema, script the current table and then rename the table to a "backup" table.

Then use insert into in order to copy the data.

Doing...

😀

Nice - keep em coming.