Shared Flashcard Set

Details

SS 2008 6 Partitions
SQL Server 2008 - Implementation & Maintenance
4
Software
Undergraduate 1
06/15/2013
Click here to study/print these flashcards.

Create your own flash cards! Sign up here.

Additional Software Flashcards

 

 

Cards

Term
List the 3 steps to create a partitioned table.
 Definition
1. Create a partition function.
2. Create a partition scheme mapped to a partition function.
3. Create the table or index on the partition scheme.
Term
partition funciton
 Definition
defines the boundary points that are used to partition data.
Term
partition scheme
 Definition
maps a partition function to a physical storage structure.
Term
SQL to create a partitioned table.
 Definition
CREATE TABLE partTable ... ON partitionScheme.
Supporting users have an ad free experience!