With the Contacts, Addresses, etc., it's a different thing than the original arc. You're talking about a person. To quote, Suess, a person is a person. You don't need to...

Andy Leonard (2/8/2010)

---

Great editorial Grant!

This reminded me of the demise of my checklist. I used to think database tuning was a matter of checking off items on my checklist, in...

GilaMonster (2/8/2010)

---

A suspect DB has to be set to Emergency mode before CheckDB can be run. There's a brief (one sentence) mention of running CheckDB in Scenario 3, right before...

I'm a little surprised that you're not recommending running CHECKDB on the database in question. Yes, it's marked as suspect, and yes, you might find a cause in the error...

Tobar (2/8/2010)

---

Great Article.

Each person must assess their own needs and responses when considering "cookie cutter" numbers. As much as we would like to believe, we are not a one size...

No, no. I think it would be much more...

Please tell me you did that from memory.

Greg Edwards-268690 (2/5/2010)

---

I couldn't see options 1 thru 4, so I took a guess at what might seem logical.

1. - Run backwards. Necessary speed would depend on whether the Turbo...

David McKinney (2/5/2010)

---

I wouldn't have thought it would perform any sort operation i.e. it wouldn't re-sort your index just because it was ascending instead of descending. I assumed it...

Followed by data structures and...

Roy nailed it. It generally has no impact until the query you're running requires SQL Server to reverse the order of the data. It can't do that for free.

Creating an indexed view is not the same thing as creating an index. Actually, it's somewhat more expensive. If your data is highly volatile, as it gets constantly updated, it...

That's not a dirty read. You're not taking out an exclusive lock on the entire table when you start reading from it. Instead you're getting locks on each row and...

Any query hint should be the absolute dead last option after every other possible tuning opportunity has been exhausted and even then, you should think three times before using them.

The...

Probably, but we're missing some context that lays down what the OP meant by the...