piotrka (5/1/2012)

---

Gregory, great article

But I have a question about read performance for RAID 5 and RAID 10. In your table you showed that RAID 5 scores Good and RAID...

Steve Jones - SSC Editor (5/1/2012)

---

jfogel (5/1/2012)

---

I don't see ever getting on board with having a production database running on a VM. Of course, things change but I cringe at...

gert.j.kruger (5/2/2012)

---

For SSD Raid 1+0 configuration I have been advised by our hosting company that the total storage space is different than for traditional drives. My understanding is that...

As long...

As a warning: run consistency checks on your RAID sets; see if you've got one or more drives that has corrupt data that your RAID level is hiding from you....

Steve Jones - SSC Editor (5/1/2012)

---

Make sure you have good backups and be careful here. When SSDs die, they die ,and you may or may not get good notice.

A quick...

For SQL 2005 in specific, note that build 5292 addresses MS11-049, which is a security update. You may want to look into upgrading to this build level as well,...

Also, use something like http://sqlserverbuilds.blogspot.com/%5B/url%5D to keep track of all the builds. Look at each CU and other for your SP, and see if you want to apply it...

I agree short-stroking (using only a portion of the fastest area of the disk, leaving the rest entirely unallocated) can significantly improve spinning disk performance, because it reduces the normal...

We could probably use questions on not only isolation levels, but also their individual characteristics, from

which allow lost updates vs. dirty reads vs. nonrepeatable reads vs. phantom reads, to snapshot...

Whether 400 fragments for a 300GB file is important really depends on whether your particular access patterns could occur with only very short head, less frequent drive head movement, but...

TravisDBA (4/13/2012)

---

I don't mean to sound depressing here, but what if God forbid, something happened to you on the way home tonight and you were gone very quickly? How would...

Randy Rabin (4/12/2012)

---

One benefit with cloud that is not always obvious to customers is that we can host hundreds of virtual servers in the same cabinet space as a few...

Read Gail's articles, and then test it to see for yourself how your particular data and queries behave.

Use the one index, then the other index - either with an index...

Lynn Pettis (4/11/2012)

---

Reorg is fully logged and can be aborted without losing any work already completed and it olny works at the leaf level so runs faster.

A rebuild is all...