The first thing to do is to select all rows where the parent ID is equal to the node ID. Eliminate/fix those, then add a constraint that blocks that...

It's definitely one of those things that looks complicated till you've done a few, and then it suddenly "clicks" and becomes very simple to understand. (Not necessarily simple to...

I think the only time I've had a table be faster because of a lack of PK has been in bulk-import situations. It is faster to import multi-million-row text...

Try it on a dev/test server first. Definitely don't mess around with the production server unless you have to.

FelixG (6/3/2009)

---

That is not rigorously correct...

As many people has said, the primary key...

jcrawf02 (6/3/2009)

---

GSquared (6/3/2009)

---

I don't have a cat. I have two dogs, and one of them is still dopey from being sedated by the vet yesterday (teeth cleaning). Does...

RedGate has a product that will do that for you.

So does ApexSQL.

Those are your best bets for getting it done fast and right.

That's the kind of thing that data warehouses are used for.

Simplest version of that for you would be to have a table that you populate daily, that has the counts...

Since you can't control where the files go, physically, on the actual disks, there's no gain to be had from multiple filegroups. Doesn't matter whether it's actually one disk,...

Do you have the installation media (DVD, most likely)? If so, you should be able to reinstall the client tools pretty easily from that.

First, costs in execution plans aren't really all that useful a datum. They are often enough dead-wrong that they can be treated as virtually meaningless.

Second, the probable reason is...

jcrawf02 (6/3/2009)

---

GSquared (6/3/2009)

---

Adam:

I hate to sound so quantum (reference to today's cartoon from the front page), but I think the principle of publishing even when there are problems with it,...

Does the table really have columns with those names? I hope that's just you annonymizing it.

As mentioned, hot spots are only very, very rarely going to be an issue....

Try rebooting.

Corrupt memory or other causes of attempted access to protected memory usually means some application didn't clean up after itself correctly. Possibly you had some app...

The irony of a post complaining about misuse of commas,...