• Mike Morin-219647 (7/23/2009)


    From the author, many years too late, but still worth commenting on: Yes, indeed sharp readers, the aggregate clause in "Summarize the Data" shoud be "count(*)" and not "sum(*)"! I still do not know how I let that slip through! Many thanks to you for catching that and passing along. To all, I've enjoyed your comments and I especially appreciate those who have taken this a step beyond (or many more steps). That is precisely what I had hoped to accomplish with this article: to give folks a starting point that they could utilize in their own work. Now that we have SQL Server 2005, the included system views take care of a lot of this, but it is still useful for anyone who is still running SQL Server 2000.

    +1 .... beside that very nice article