Originally posted by: sunliners81
I'm having a problem with running out of tempdb space when attemping an aggregate query with group by. I'm attempting to sum two columns. If I just select count(*) on the from statement, 721,204,305 rows are returned. What could be an alternitive here?
Building an OLAP cube maybe your solution. OLAP cubes are the champions of aggregation. In fact OLAP cubes are nothing but aggregations.
Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server 2005 OLAP Training, SSAS, SSIS, SSRS: http://www.sqlusa.com/