Monday, August 31, 2009

MCTS 70-433 SQL Server partition_function "range right"

A simple example ...


create partition function partition_function (int) as range right for values (10000,20000,30000);


create partition scheme partition_scheme 

  as partition partition_function to (part1, part2, part3, part4);


create table employee (

  empID int,

  empName varchar(50)) on partition_scheme (empID)


Then employee 20000 ends up in part3 ...


No comments: