PASS Community Summit 2008: Program Sessions (Application Development)

A data warehouse can grow to billions of rows and several terabytes. This presentation is a look at the techniques used to manage all that data. It is geared to application developers and dbas. The topics: - What's Big? - The concerns that are raised when a database gets big: - Load speed - Query performance - Backup/Recovery time - Addressing each of the concerns: - Loading into empty tables - Partitioned Tables and Partitioned Views for improved query performance - Managing Read_Only status on filegroups to minimize backup time. - Organizing data through files and filegroups. - Sliding window techniques to combine the above. The demonstrations takes the user through creating, loading and querying using multiple filegroups and both partitioned tables and partitioned views. The implication for query optimization of each technique and a comparison of the results on a 2 terabyte database will be shown. New relevant features of SQL Server 2008 will be discussed and demonstrated.

Register Now for PASS Community Summit 2008!