SQL Server 2008: 1 Trillion Row Query in seconds via Project "Madison"

“Project 'Madison' was announced as the release of SQL Server that will be integrated with the recent DATAllegro acquisition. Project 'Madison' will be capable of handling the most challenging data warehouse workloads which is key since the data warehouse is the hub of any BI solution. At the BI Conference, SQL Server demonstrated how capable […]

“Project 'Madison' was announced as the release of SQL Server that will be integrated with the recent DATAllegro acquisition. Project 'Madison' will be capable of handling the most challenging data warehouse workloads which is key since the data warehouse is the hub of any BI solution. At the BI Conference, SQL Server demonstrated how capable this technology really is by using current reporting tools to perform a 1 trillion row query on a 100 TB data warehouse with results returning in seconds,” revealed Anthony Carrabino.

Full Article