Well, it was just a thought...what about the original suggestion of splitting to yearly tables?

It actually sounds like you are working on a datawarehouse solution. Have you used Analysis Services for this kind of stuff?

Frank,

nice link. neat technique. Actually, this goes to the last point I was making...the technique shown will only be easily accomplished if the tables have a fixed number...

Actually, it's quite simple, and doesn't have much to do with whether there is a clustered index on the table or not, except if the clustering key is actually needed...

The reason I recommend using one table for each year, BTW, is that you ensure a fixed number of columns in the table, which means that in some of the...

Very interesting situation, and congrats for getting this far! A couple questions: I am assuming that you are not reloading the same data month after month, just because you...

We use Progress9 with OpenLink 4.0 drivers. OpenLink provides ability to set up ODBC DSN to the UNIX box and act as if it were any old data store...licensing...

SET SHOWPLAN_TEXT ON

GO

SET NOEXEC ON

GO

SELECT 2.Early FROM Morning 2

ORDER BY BrainPower DESC

GO

quote:

---

Point blank a nonclustered index will always read more pages as oppossed to a clustered if there is a clustered index on...

quote:

---

..how did you manage to get the execution plan into this kind of ascii art ???..

---