wow. super coding! Thanks!

The article is great. had a question: In Production, is it possible that the login that runs such a query might not have access to Master..syscolumns and so I should...

I see ... I wish I were still a student. The pros are making me nervous asking my next "real-world" question on this site again! 🙂

Thank you Sir! Not sure how to interpret the other replies and so I will leave it at that. The article was really helpful. Thank you again.

This should work:

WITH YOYCTE ([Year], [TotalMembers])

AS

(

SELECT Years = DATENAME(year, EnrollDate),

COUNT(MemberID) as TotalMembers

FROM dbo.Enrollment

...

Thanks Craig. I know it was an open ended question...but I had to ask. 🙂

hmmm...I read through the indexing article regarding equality and inequality predicates. I do understand that. Thanks...

Great Thanks! Clearly I am not understanding partitioning all that well then. Yes I was also thinking of putting the filegroup with the partitioned tables in a different set of...