Great info. Thanks all.

Any recommendations for books that cover this topic in depth?

In that case, I have another question: In what ways is the index physically implemented differently depending on the order of the columns within it? I understand that...

I am going to implement this as a separate table. I don't want the additional overhead of the index on the table.

But I do have a question: Is this...

I just updated the stats with a 20% sample size; this took about 30 minutes. The DISTINCT query's performance does not seem to have improved.

Matt Miller (4/18/2008)

---

Steve -

Is the drop down list showing the LAST 8 days? If not - is there a pattern in to what is shown? I'm just...

Michael Earl (4/18/2008)

---

I don't think I would name a table MyTable, but ok.

Is the Day field indexed? An index on just this field should make the query much faster.

I...

I don't understand. I did post it. Here it is again:

SELECT DISTINCT Day FROM MyTable ORDER BY Day DESC

Unfortunately, I think you're right about the dynamic SQL and building the query string on the fly. That is while I'll likely do. Plus, it won't force me...

SQL Server 2000 doesn't support the OPTION (RECOMPILE) option at the statement level. However, I did try adding WITH RECOMPILE on the stored procedure definition (for proc-level recompilation), and,...