Yes, it seems you're right. I didn't know - I've never needed to reinstall a SQL...

What about reverse approach: try to re-install it to repair the instance, then the uninstall might work better.

Thanks!

I checked my execution plans and it already makes the difference - the plan with TOP is much more accurate in the estimated number of rows.

Thats a good point...

I wonder if the TOP specification has any special impact (as claimed) on the query execution - I tried to omit it (replacing it with WHERE PG.rn BETWEEN lowRn AND...

Sorry, I'd like to stop our disputation about security/backups because:

1. It seems to get off-topic: this forum was intended to discuss the performance gains of separating MDFs and LDFs on...

Well, that's clear. I already mentioned RAID 1 as the only acceptable use of two drives (see my first post).

Anyway, how does it relate to giving mdf and ldf files...

Hey, what's wrong?

Consider a small firm: Could you please explain me why I should make my customer spend money for more disks while both 🙂 users are content with the...

Ted Krueger:

I still think that two drives are no good configuration: you cannot have RAID on two drives while having mdf and ldf on separate spindles.

It is clear that...

Malcolm Daughtree (5/13/2009)

---

There really is only one answer to this and that is ALWAYS ... Even if it's a small system and IO is not an issue, think about that...