This session will address the things to consider when architecting a large, high-performance relational data warehouse, especially one that is host to unpredictable ad hoc queries. The discussion includes some of the new features and enhancements in SQL Server 2008, some of which result in a change in the approach taken in prior versions of the product. It also includes methodologies for creating and storing pre-aggregated result sets to facilitate mainstream queries and reports. Live demos will support the assertions made during the presentation.
Register Now for PASS Community Summit 2008!