Category Archives: Performance
SQLHero delivered June Session in Microsoft SQL Server 2008
|Topic||Microsoft SQL Server 2008|
|Date||Dec 29, 2009|
|Time||10:00 – 3:00|
|Location||Microsoft, Smart Village|
1. What is Partition table?
Data is partitioned horizontally by range
2. How to Create Partition Table?
You can create partition table by 2 ways
- wizard in SQL Server 2008 New
But you must understand 2 things before creation Partition Tables
Partition Function: Partition functions define partition boundaries and Boundary values can be assigned to LEFT or RIGHT
Partition Scheme: A partition scheme assigns partitions to filegroups
3. How to Create Partition Table by wizard in SQL Server 2008?
Right click on table then go to storage then select Create Partition as in fig bellow
Select a column you want to use it in partition as in fig bellow
Create Partition function as in fig bellow
Create Partition Scheme as in fig bellow
Determine ranges as in fig bellow
Create Partition by select run immediately as in fig bellow
Congratulation your table now partitioned
4. How to Create Partition Table programmability?