I've always done:

2 RAID 1 for OS

4 RAID 5 for MDFs

2 RAID 1 of LDFs

But I think it depends on what you are using the DBs for, I used SQLIOsim...

Try this:

http://msdn.microsoft.com/en-us/library/bb510680.aspx

RBarryYoung (4/3/2009)

---

Johnny Wyskiel (4/3/2009)

---

I'm not asking anyone to rewrite my script, I'm looking for a new way to do something I have to do in several situations (i.e. execute a...

So after reading this thread and the one from the mailing list today (http://www.sqlservercentral.com/Forums/Topic675554-8-1.aspx). I still have a few questions on how some things are accomplished without cursors....