Title: Architecting a Large Scale Data Warehouse with SQL Server 2005
Abstract: This session discusses best practices and real-world experience in architecting a large scale and high volume data warehouse using SQL Server 2005. Review the techniques required to handle the transformation and loading of over two billion rows of transactional data on a semi-weekly basis. See how the advanced features of SQL Server 2005 Integration Services and Relational Database — including indexing and table partitioning, CLR user defined functions, pivot functions, etc. — contributed to a successful solution.
Australian Speaker: Mark Morton?-still need to talk to mark
New Zealand Speaker: