GilaMonster (2/5/2010)

As for your real reporting indexes, you need to decide where the tradeoff is. Do you add more indexes (slower inserts, longer maintenance, larger backups) and have all your...

GilaMonster (2/4/2010)

---

So there are no queries that filter on AffiliateId or PartnerLocalDate without also filtering on CampaignID? Nothing that filters on just SubId?

I'm actually not sure what it is that...

Actually, I read your link some time ago. Quoting from it:

"So, what’s my rule for the order of columns in an index key? Put the most selective columns first, when...

There are queries that filter on 1, 2, 3, or up to 4 columns. The indexes represent the search criteria for an entire set of queries, some using "OR", some...

Gail (GilaMonster) requested that I post specifics so I will.

The indexes in the referenced table are designed to provide the highest degree of speed for reporting purposes in an...

Thanks for the details, Gail.

I should have posted my question about indexing ORDER BY and GROUP BY clauses as a Best Practices question. I think that would have been...

Thanks for both of your replies.

I review all queries submitted by our development staff so I know that they are all correctly and efficiently written, or I specify changes...

I searched in the Performance Dashboard folder on our server, found the file "Setup.sql", opened it in Management Studio, then searched for "DATEDIFF", found it at line 276, replaced it...

Michael and Jeff,

Thank you for your contributions on using CHECKSUM as a way of searching for equalities on VARCHAR(MAX) datatypes.

I think there are a few places in our databases...

Exactly. There is...

Thanks for your reply, Jason.

And thanks for your indisputable reply, Gail. It will end all debate on the subject. In answer to your "Why?" question, it's because this particular programmer...

Gail,

I reviewed your PowerPoint presentation. Unambiguous and to the point. Excellent. Thanks.

And I think I want to attend PASS next year.

LC

Thanks, GSquared.

The link you suggested gave me the most unambigous answer I've ever received.

I am in your debt. 😀

LC

Ian,

Regarding your comment:

"The two like queries you are using will never use the index because of the % at the front of the predicate. That's telling the optimiser to look...

I decided to create a more aggravating set of test conditions to see if I could obtain more definitive results.

> I made the created records much larger, so that only...