SQL Server 2008 R2: Creating and Altering Partitions
IT professionals who have jobs in which database administration is their main area of responsibility, or who work in environments in which databases are central to their job roles. These job roles include:
- IT generalists who work in environments in which SQL Server 2008 R2 is part of an overall solution
- IT professionals who manage systems that run SQL Server 2008 R2
- IT professionals who work with third-party applications that are built on SQL Server 2008 R2
- Developers who build applications that use SQL Server 2008 R2
The prerequisites for the exam are that candidates should have one to two years of experience using Microsoft SQL Server 2008, SQL Server 2008 R2, or two to three years of experience using a previous version of SQL Server.
SQL Server 2008 R2 offers the use of partitions to manage subsets of data for large tables and indexes. Partitions can be used to improve the read/write performance on tables within a database by allowing the data within tables to be spread across multiple filegroups, whereas standard tables must be contained within a single filegroup. Data that is stored within partitions is treated as a logical entity, and the partitioned tables and indexes support the same properties as a standard table. SQL Server 2008 R2 allows views to be partitioned, which joins data from multiple tables from one or more servers. The data is returned as one set of information, making it appear as if it were from one table within one database. When partitioned views are used to access multiple tables from various servers they are known as distributed partitioned views. These are used to gather data from independent servers or a federation of servers. This course demonstrates how to create and manage such partitioned tables and indexes, and distributed partitioned views. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-433 TS: Microsoft SQL Server 2008, Database Development. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Database Development certification.
Partitioning Database Objects
- recognize how to create table and index partitions
- recognize how to modify table and index partitions
- recognize how to create and use distributed partitioned views
- create a partitioned table
- create a partitioned index
- modify a partitioned table
- create a partitioned view