Home > SQL Server > Data Warehousing: Table Partitioning for SQL Server 2005/2008

Data Warehousing: Table Partitioning for SQL Server 2005/2008

Course Code:	SQSPTI
Duration:	2.5 days
Audience:	Database architects, developers and administrators of OLTP and/or data warehouse solutions.
Prerequisites:	At least one year's experience with SQL Server 2005/2008.
Summary:	This course is designed to address complexities inherent in Very Large Databases (VLDBs), e.g., 100GB+, as these relate to manageability, maintainability and performance. Although mainly suited for data warehousing and business intelligence scenarios, large OLTP systems have been known to benefit. Particular emphasis is placed on SQL Server 2005/2008 options with regards: Table partitioning Index partitioning Indexed views Table maintenance Performance Sliding windows Partitioning parallelism Data archiving Partition movement Partition consolidation Best practices and performance
Objectives:	Upon completion of this presentation, the delegate should be able to: Partition a relational data warehouse Appreciate the variables that influence table/index partitioning Design sliding window scenarios Optimise query performance.
Format:	Lecture and hands-on (about 45%).
Detailed Outline

Course Schedule