In general you should not run the GUI profiler continuously. a) it has a MUCH more significant overhead on the server than profiling to a local disk file and...

I would like to inject here that people need to be very careful about the "test it yourself" mantra. What is optimal for one set of circumstances could be...

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...