Todd Engen (3/6/2008)

---

I've seen that that behavior before and it was an application issue;in query analyzer it took less than a second to return the results, from the application it...

mmh, Answer 1 meets the cost and space requirements but totally missed the performance requirement: "for a busy OLTP system"

I would prefer answer 3 (Raid1 for data) and explain the...