If you have a sufficiently long maintenance window I see no reason not to do the update stats with fullscan every time. I don't think it can make things...

1) >>Does partitioning with only one set of RAID have any advantage?

It can actually have a DISadvantage in causing additional head thrashing and seek/access times, resulting in WORSE performance, especially...

Things that make you go "HHHMMMMMMMM"!! :hehe:

Better to have too much work than not enough though, right?? 🙂

PiMané (9/10/2009)

---

That's if the primary key is the clustered index, which it doesn't have to be. There's no real problems with a random guid as the primary key. The problem...

Paul White (9/9/2009)

---

It may be an awesome and flawless product. I might have to check it out too.

I'd like to think there will always be a place for (appropriately...

>>The DTA didn't help me either. I used another software that provided me with much better results - I think it was called somethink like qure sql.. I'm sure Google...

Glad you didn't say like doctors there since my wife is an OBGYN! 🙂 Of course...

Actually my rates are definitely...

:w00t:

This type of system screams for a dynamic sql based search sproc. Difficult to construct properly, but by far the most efficient mechanism you will get. I have...

Personally I love the OP's original design statement!! And no, I am not laughing here. The more situations like this in existence (and there are LOTs of similar...

You should be very thankful you got the error, because otherwise you would have bad data in your system and not know it. The query needs to be rewritten...

True, but I have changed only one thing: a unique index to a nonunique index. Now call me old fashioned, but I believe that there should be either no difference...

Jeff Moden (9/7/2009)

---

I'd love to see a performance test between HID's and the Nested Set Model for both up and downline queries as well as the addition and deletion of...